Oracle

CREATE OR REPLACE FUNCTION idfms.func_dec236 (parm in INT DEFAULT 0)RETURN VARCHAR2Is/*10 binary number to 36 binary number*/SRC VARCHAR2 (+): = ' 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ '; --Change to another string, which is any binaryLEN INT;Res

First, the use of imp/exp. Pilot out the source library, then create a new library to create a table space, and then import. (this is said to be possible, provided that the new library cannot have a tablespace with the same name as the Source

Use the cmd Operation command to export, the details are as follows:The 1:g:\oracle\product\10.1.0\client_1\network\admin directory has a Tnsname.ora file with the following contents:Cmstar =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP)

Introduction This article records the pitfalls of Oracle programming that are easily encountered in daily development and some usage tips that are not updated regularly.1.sum (), Max (), Min (), AVG () and other functions get null

Oracle 11g Database Modified character SetNls_characterset I set the database to ZHS16GBK while developing the required UTF8According to the development reactionWhen inserting a piece of data into a database table, the Chinese is changed to resemble

A long time ago I wanted to do some tutorials about VirtualBox, and many people asked me virtualbox how to use it. I will answer them all. There are few things online about VirtualBox, I want to write something of my own and share some of my

Today want to be a staff birthday reminder module, suddenly found that the statement is not good to write, so Baidu summed up a bit, hehe.select * from table name where humanstate= ' normal incumbency ' and  (To_number (To_char ((dateOfBirth), ' mm '

Recently do the DRP project, can be the Oracle toss miserably, the first time installation of rough doomed after the temper, now I put these blood and tears of history are organized here, hoping to help you in Oracle's connection less detours, less

The complete database file set includes: database startup parameter file, control file, data file, log file. The location and name of the file can be obtained in the following way.parameter File$ORACLE _home/dbs/spfile[$ORACLE _sid].ora$ORACLE _home/

bug--wrong Kernel statistic in Version 2.6.39-400.x.x between Oracle Linux 5.9 and Oracle Linux 6.4Reference from:wrong Kernel statistic in Version 2.6.39-400.x.x (Doc ID 1552713.1)Suitable for:Linux os-version Oracle Linux 5.9 with Unbreakable

　　The key to ensuring the consistency of Oracle database reads is the SCN. Each data block will record the SCN for a transaction submission. At the same time, each data block contains a transaction table (ITL), and the transaction must obtain an ITL

One, concurrencyConcurrency is the most important feature of an OLTP database, but concurrency involves the acquisition, sharing, and locking of resources.Mysql:MySQL is a table-level lock-based, the granularity of the resource lock is very large,

--、、、、、、、、、、、、、、 Common single-line function 、、、、、、、、、、、、、、、、、、、、、、-------------------commonly used character functions------------------------initcap (char): Capitalize first letterSelect Initcap (' Hello ') from dual--lower (char): Convert to

Work with SQL Server more, Oracle can be said to be small white, recently want to use stored procedures to complete the document copy function, the results encountered a variety of problems, in fact, is very simple problem, but for me still spent a

Serial Number rules table Rul_sequence: Data in the Rules table:Generate serial number-assisted stored procedures:CREATE OR REPLACE PROCEDUREProc_getseqence (Seqcodeinch varchar2, Returnnum outVarchar2, Messagecode outvarchar2)--exception

One: Application Scenarios for table partitioningUsed to manage tables that contain large amounts of data.Two: Advantages of table partitioning1. Improve the availability of data2. Reduce management burden3. Improve the performance of the

First, the indexIndexes are a quick way to access data to improve database performance. Indexing makes it possible for a database program to find the data it needs without having to scan the entire table, like a book's directory, to quickly find the

Today, the Oracle client is installed in the CentOS6.4 operating system, centos6.4oracle After the installation was complete, the environment variable settings had been exhausted for a long time. Later, I knew that I had to restart the environment

Common Oracle commands and common oracle commands in Linux 1. Start the oracle database: // Switch to an Oracle user: [Root @ server36 ~] # Su-oracle   // Enter the sqlplus environment. The nolog parameter indicates no Logon: [Oracle @ server36 ~] $

How to query the variable value bound to an Oraclesql statement Alter session set nls_date_format = 'yyyy-mm-dd, hh24: mi: ss'; set linesize 400col SQL _Id format a20col name format a20col datatype_string format a14col value_string format a20select