Oracle

　　One, the Oracle large_pool_size size setting value how muchJava_pool_size:Specifies, in bytes, the size of the Java storage pool, which is used to store Java methods and classes that define representations in shared memory, and Java objects that

The ADR path is determined by the parameter Diagnostic_dest parameter:sql> Show parameter diagnostic_dest NAME TYPE VALUE--------------------------------------

CREATE TABLE T_hq_e(XINGM VARCHAR2 (10),CHENGJ number is not NULL,Jiatzz VARCHAR2 (15))Tablespace SYSTEMPctfree 10Pctused 40Initrans 1Maxtrans 255Storage(Initial 16KMinextents 1Maxextents Unlimited);--ADD comments to the columnsComment on column

1. The PDB to be used for cloning as read-only status: Startup Open Read OnlySelect from V$pdbs; con_id NAME open_mode-------------------------------------------------- 2 pdb$seed READ

Correlation QueryCartesian productEach row of each table that makes the associated operation is combined with each row of the other table, assuming that the number of record bars for the two tables is x and Y, the Cartesian product will return X*y

1.decodeMeaning explanation:Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value)The function has the following meanings:IF condition = value 1 ThenRETURN (translation value 1)elsif condition

The Oracle database has no self-increment field settings, and you can set the field self-increment as the ID by function.1. CREATE table Tsequence to store the next ID of each table.2. The creation function is similar to the following:1 CREATE OR

Crud additions and deletions change create read update deleteInstallation of the 1--oracle databasesystem default creation of two user sys and system password customizationSuper admin: SysAdministrator: SystemPassword: 56152--Starting a database

Direct code/// ///paging through SQL/// /// /// Public Static stringGetpaginationsql (stringSQL) { intIntpagesize =int. Parse (httpcontext.current.request["rows"] ==NULL?"0":

Original address: http://blog.itpub.net/4227/viewspace-69049/Upgrade this evening, there is a stored procedure anyway compile not past, prompt permission is insufficient, but the user is DBA authority, online A check only know, Oracle stored

15, the creation of a function requires a return value, must be called in the statement, when more than one return value is required, using the Out parameter type, querying the property in the User_procedures table, querying the source code in the

Oracle policies can limit query, modify, delete, new, and so on, just contact, the query to do a test:Reference http://blog.csdn.net/diyyong/article/details/19552637Use the following:Begin--Call the procedureSys.dbms_rls.add_policy (Object_schema =:

Oracle row-to-column and column-to-row, oracle column-to-column Conversion I. Row-to-column Conversion In some application scenarios, such as student scores. The scores of all students are saved in a table. When we need to display the scores of each

Detailed steps for manual database creation in Oracle The steps for manually creating a database in oracle are as follows: 1. Compile the initialization parameter file2. Set Operating System Environment Variables3. Create an instance4. Connect to

Oracle numeric FunctionsNumber function 1, integer function (ceil rounded up and floor rounded down) select ceil (66.6) N1, floor (66.6) N2 from dual; 2, power) and evaluate the square root (sqrt) select power (3, 2) N1, sqrt (9) N2 from dual; 3,

Oracle non-archive mode and archive mode backupInconsistent backup: Because the backup operation cannot be completed instantaneously, while data files are being written at all times, the SCN time is changing, and when the nth data file is backed up,

Auto-start setting of oracle11g on linux Generally, it is best to manually start the oracle server. If this problem occurs, it can be solved on site, but it is also worried that sometimes the machine will fail. After Automatic restart, In order to

Oracle character Functions1. String truncation select substr ('abcdef', 1, 3) from dual 2, find the sub-string position select instr ('abcfdgfdhd', 'fd ') from dual 3, string connection select 'hello' | 'Hello world' from dual; 4, 1) Remove the

Official Oracle and oracle website(ORACLE 10g) "the" OraOLEDB. Oracle.1 "provider is not registered on the Local Computer" Problem Solving:In the C # program, you must use Provider = OraOLEDB. Oracle.1 to access the ORACLE database. However, an

Introduction to ORACLE Database asynchronous IOAsynchronous I/O (AIO) is an enhanced function provided by the Linux kernel. It is a standard feature of the Linux 2.6 kernel. Of course we can find it in the patch of the 2.4 kernel. The basic idea