Oracle

1. Single-line Comment--multiline comment/*...*/2. Naming conventions for glyphs1) When defining variables, it is recommended to use v_ as a prefix v_sal2) When defining constants, it is recommended to use C_ as a prefix c_rate3) When defining

Oracle Learning--Looping statements Loop loop: Create or Replace procedure Pro_test_loop ISI number;begini:=0;loop i:=i+1; Dbms_output.put_line (i); If I>5 then exit; End If;end Loop;end Pro_test_loop; While loop: Create or

Oracle redo log files are used to recover data in the event of a database crash, by default, three files Redo01.log/redo02.log/redo03.log, file groups are recycled, and log file updates are busy in applications with more entry and update operations.1

Atomic NatureA transaction is a complete operation. The steps of a transaction are non-divided (atomic), either executed or not executed. --Create TABLE Account_money ( ID number (4) Not NULL, name varchar2 (4) isn't null, money number ( 5,2)

1 Creating Stored ProceduresCreate or procedure my_procedure (PARAM1,PARAM2) isBegin...End2 Judgment StatementIf X>0 ThenBegin...EndEnd if3 for LoopFor ... Loop...End Loop4 Looping through CursorsCreate or Replace procedure my_procedure () as cursor

public bool Insertoracle (DataTable DataTable, String sql)//Oracle SQL query is table header {string connstr = Wirel essCenterDAL.Common.GetConnDMS1; using (OracleConnection conn = new OracleConnection (connstr)) {try {

First, system table Space Data Files Migration :Sql> conn/@tmpdb as Sysdba connected.sql> desc dba_data_files;is the name empty? Type-----------------------------------------------------------------------------file_name VARCHAR2 (513) file_id

Use Oracle RowNum to make table sort field values contiguous1. Requirements DescriptionThe table (Eval_index) has the following fields: Table field Describe Description Id Primary key

How to delete a large number of small trace files in oracle When files are deleted in batches on the AIX platform, the following error occurs: Ksh:/usr/bin/rm: 0403-027 The parameter list is too long Cause: This is mainly because the AIX Kernel

Oracle Transaction Features and oracle transaction detailsAtomicity A transaction is a complete operation. The operations in each step of a transaction are inseparable (atomic); they are either executed or not executed. -- Create table

About ORA-03113: End of a communication channel" Author: iamlaosong A SQL query statement, successful execution or error, irrelevant to the statement, but related to the value in the condition, the error is the ORA-03113: The end of the

Impdp experience ORA-39001, ORA-39000, ORA-39142Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target data version, the

Test ACS in Oracle11.2.0.1.0 In version 11.2.0.1.0, ACS (adaptiver cursor sharing) is tested as follows: 1. when binding is effective, CBO uses the binding variable. When the histogram is accurate, CBO compares the same SQL statement with the

Oracle 12cRAC mobile MGMTDB database data file Method In the previous Blog, we introduced the concept of MGMTDB in Oracle12c RAC. For details, refer:   Oracle 12 cRAC MGMTDB description Http://www.bkjia.com/database/201412/359252.html   By default,

[Oracle] Chapter 1 create authorization Chapter 1 create authorization in ORACLE Run the following command to view control files, data files, and log files: Control File: Desc v $ controlfile; Data File: desc v $ datafile; Log File: desc v $ logfile;

PLSQL _ basic Series 3 _ merge operations UNION/union all/MINUS/INTERSET, plsqlinterset 2014-11-30 BaoXinjian I. Summary If we need to display the results of two select statements as a whole, we need to use the Union or Union All keywords. Union

[Oracle] Chapter 5 cursor and trigger Chapter 5 cursor and trigger Cursor: Implicit cursor: % FOUND, % NOTFOUND, % ROWCOUNT 1.% FOUND usage. The % FOUND attribute returns TRUE only when the DML statement affects one or more rows. The following

[Oracle] Chapter 4 Exception Handling Chapter 4 Exception Handling PL/SQL blocks are the basic units for PL/SQL programs. Combine logic-related statements and statements PL/SQL consists of three parts: Declaration, executable, and exception handling.

Oracle SQL statements are fast and slow Today, I encountered a very strange problem. One SQL statement is very slow in PL/SQL developer and takes 9 s. The problem SQL: SELECT * FROM GG_function_location f WHERE f. parent_id = '000000'; The

[Oracle] Chapter 3 index view Sequence Chapter 3 index view Sequence Sequences are database objects used to generate unique, continuous integers. A sequence is used to automatically generate a primary key or a unique key value. Create sequence