Oracle

Oracle dbms_output two minor issues of dbms_output in oracle 1. If the content of dbms_output.put_line cannot be displayed, You need to first input set serveroutput on in the command line; just repeat it, after dbms_output.put_line content can be

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

Stored PROCEDURE --- create or replace procedure cuiyaonan2000 (stored PROCEDURE name) (parameter 1 in number, parameter 2 in number, parameter 2 in number, parameter 3 OUT Number // The above is in, which indicates the parameter you pass to the

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

Oracle Hack With As requirement: there is an old permission table With 7 levels (1-7 ). Except Level 1, each user ID is associated with a superior user ID. Www.2cto.com creates a new table and extracts the IDs of each person corresponding to the

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

Oracle Data complex type (1) 1. pls_integer ------ this type is calculated by the cpu. Some overflow may cause errors, but the speed is fast. binary_integer --- It is executed by Oracle and will not overflow, but the execution speed is slow, because

Linux RAC Environment check script echo "#******************************* OS check ******************************* "www.2cto.com echo 'hostname' echo "kernel" echo "# check OS" echo "kernel" uname-aecho "# check swap" echo "kernel" freeecho "# check

Oracle database stored procedures and task calls in oracle databases can be scheduled to call stored procedures by creating dbms jobs.What about creation? Although there are some materials on the Internet, the syntax is still 'amazing. I tried it

There is a relational database with three basic tables. The table structure is as follows: table 1 student no. stu_id name age gender No. depart_id Table 2. SC student no. stu_id course No. course_code score Table 3. courseWww.2cto.com course No.

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

Copy install oracle10g for AIX5.3 www.2cto.com #! /Usr/bin/kshx () {chdev-l aio0-P $ * if [$? = 0] then dspmsg smit. cat-s 25 763 'changes will become valid tive at next lead E m restart' fi} x-a minservers = '30'-a maxservers = '60'-a autoconfig = '

(PL/SQL) basic operations 1. function. To improve the system performance, the database storage module is required so that you can create a stored procedure (SQL window) from the basic application www.2cto.com 1) create or replace procedure

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 random row fetch statement: 1. full table scan 2. sample table Scan www.2cto.com Full table Scan (Full table Scan) Full table Scan returns all records in the table. Perform a full table scan and read all records in the Oracle table to check

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

There are two simple examples of exists, not exists, and in usage in Oracle to illustrate the efficiency of "exists" and "in" 1) select * from T1 where exists (select 1 from T2 where T1.a = T2.a); T1 has a small amount of data, while T2 has a large

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 auto-incrementing field sequence created by Oracle is not as convenient as the auto-incrementing SEQUENCE in SQL Server. If you want to achieve the effect in SQL Server, it is not very troublesome. You need to create an auto-incrementing