Oracle

Pl/SQL tips flexible use 1.PL/ SQL Developer remember login password www.2cto.com when using PL/SQL Developer, for the convenience of work, it is hoped that PL/SQL Developer remember login Oracle username and password; setting Method: PL/SQL

Oracle data deletion statement -- view the current SCN value SELECT dbms_flashback.get_system_change_number from dual; -- SELECT to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss ', to_char (DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER) as scn from dual; --

When the optimization of non-equivalent SQL statements is coming off work today, a group of friends is asking how to solve the problem: the original SQL statement is as follows: www.2cto.com insert/* + append */into dr_bps_guna_yyyymm_ch_01select

Sequence in Oracle is a so-called serial number in oracle. It is automatically added each time it is obtained. It is generally used in places where the sequence numbers need to be sorted. Www.2cto.com 1. create sequence you must have the create

When PowerDesigner generates an SQL script for database table creation, double quotation marks are used to generate an SQL script for database table creation. Especially for Oracle databases, table names are usually enclosed by quotation marks. In

Oracle Database exporting users oracle exporting users can include triggers, functions, and other database elements, which is very convenient. Example: The user who exported the user name/password lgp/lgp, and the database instance name srorcllgp

Multiple values in a field in Oracle separated by commas (,) have encountered abnormal problems recently. A field has a field association relationship with another table, the Unit Field stores multiple IDs separated by commas (,). There are quite a

Red Hat to install oracle 10g system environment configuration script redhat before installing oracle linux needs to configure some system environment, each configuration is troublesome, for convenience, write a simple script, in rhel5.8 system test

Oracle order by: In the decode SQL statement, www.2cto.com order by can be sorted in the specified order. No, for example, NCH HCH ACS TWN .... order by decode (col, 'nch ', '1', 'hch', '2', 'acs', '3', 'twn', '4', col) col indicates the data found

Oracle learning notes-command and Function Command www.2cto.com usage format Description Example DescDesc table name display table structure Desc bk_bookinfoSet lineSet line n Set the screen output to n characters wide Set line 100LL display SQL

Oracle SQL analysis tool uses explain plan to analyze SQL statements: www.2cto.com explain plan is a good tool for analyzing SQL statements. It can even analyze statements without executing SQL statements. through analysis, we can know how ORACLE

ORACLE scheduled execution program is not familiar with database jobs for DBAs, because it is often necessary for the database to automatically execute some scripts, back up the database, or refine the data at regular intervals, or optimize the

Oracle stored procedure Test SQL code alias -- SQL statement: declare I _result NUMBER; s_accountnumber VARCHAR2 (64); s_batchno VARCHAR2 (20); s_sequence VARCHAR2 (22); begin p_e_pin (I _result, s_accountnumber, s_batchno, s_sequence)

Oracle DBCA database encountered ORA-21561: OID generation failed error solution tonight when using DBCA database creation, enter the following interface, the machine on to go to the bath. Www.2cto.com results after the bath back, found that the

Oracle execution plan table access operations this article records some table access operations www.2cto.com display the execution plan Stored Procedures refer http://www.bkjia.com/database/201303/192688.html (1) table access full table scan: use

Oracle Data Guard switchover checklist on standby sitesql> select * from v $ version; BANNER www.2cto.com Release Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production PL/SQL Release 11.2.0.3.0-Production CORE 11.2.0.3.0

Oracle creates and deletes users, roles, tablespaces, imports and exports ,... command summary // create temporary tablespace www.2cto.com create temporary tablespace zfmi_temptempfile 'd:/oracle/oradata/zfmi/zfmi_temp.dbf 'size 32 mautoextend

The Oracle NULLIF function syntax of the Oracle NULLIF function is NULLIF (expression 1, expression 2). If expression 1 and expression 2 are equal, a null value is returned, if expression 1 and expression 2 are not equal, the result of expression 1

DBMS_RANDOM.STRING usage in Oracle DBMS_RANDOM.STRING (var1, var2) This function has two parameter values: u, l, a, x, pu --> uppercasel --> lowercasea --> mixed casex --> uppercase, alpha & numericp --> any printable char and above parameters can

Simple demonstration of Oracle Database for table primary key column concurrency causes row-level locks this article content software environment simple demonstration of Oracle Database concurrency causes row-level locks this article simple