Oracle

Tips for SQL Developer 1. Set the logon password of plsql developer by default. Choose 'tools '--> 'preferences'. In the 'oracle 'column of the window, select the 'store with password' option in 'logon History,Log out of PLSQL and select the

In oracle, use a regular expression to intercept the string SQL code-the following two statements, split the summary into two strings: regexp_substr (summary, '[^ \-] +', 1, 1) as _ work regexp_substr (summary, '[^ \-] +', 1, 2) as _ home -- query

-- Create a connection to create database link name (dblink) connect to database username identified by "password" using 'Connection string'; if you create a global dblink, you must use either mongom or sys, add public to the database. Create public

Oracle sequence attribute value description create sequence emp_sequence increment by 1 -- add a few start with 1 each time -- count NOMAXvalue from 1 -- do not set the maximum value NOCYCLE -- always accumulate, no loop, if CYCLE reaches the

1. Download The 11gR2 linux client from the oracle website. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linuxsoft-085393.html 2. use ftp to transfer the Installation File linux_11gR2_client.zip to CentOs. Note that

During stress tests on the oracle database on 136, we found that the physical space occupied by the database data files was more than 20 GB, however, after we clear the data of each table (truncate drops each log table), we find that the actual data

/* The memory space parameters allocated for creating bitmap indexes to accelerate index creation */show parameter create_bit; www.2cto.com/* change the index storage parameter */alter index index_name pctfree 30 storage (initial 200 k next 200 k );

Oracle implementation Stored Procedure return query result set method -- Implementation Stored Procedure return query result set method, the following code from the network finishing

[SQL] create table tablea (id int, ip varchar (15), apps varchar (10) insert into tablea select 23, '2017. 0.0.1 ', 'aaa' go www.2cto.com declare @ Variable1 varchar (15), @ Variable2 varchar (10) select @ Variable1 = ip, @ Variable2 = apps from

Try to change the access pathIf an SQL statement causes sorting, it usually performs a full range scan. The following SQL statement: Select * from product where item_cd like 'AB %' and category like 'C % 'order by item_cd desc. Due to the sorting

Understanding of oracle ITL (Transaction slot) 1. ITL Description: ITL (Interested Transaction List) is an integral part of the Oracle data block, which is located in the data block header (block header ), itl is composed of xid, uba, flag, lck, and

Oracle modify character set view oracle server code: select * from sys. nls_database_parameters; check the client code: select * from sys. nls_session_parameters; modify the client encoding: open the runner and go to the Registry to edit and run --

In general operations, we may encounter situations where the same or identical data source is to be inserted into different data tables. Oracle9i introduces the multi-table insert operation in the following three forms. unconditional (Unconditional):

Services to be enabled by ORACLE:Password: Start the Oracle 11G service: @ echo off @ ECHO start Oracle 11g service net start "OracleDBConsoleorcl" net start "OracleOraDb11g_home1TNSListener" net start "OracleServiceORCL" @ ECHO stop Oracle 11g

Oracle experiment: Use bbed to restore the entire process of accidental deletion records. 1. Prepare the test environment: SQL> create table c as select * from dept; Table created. SQL> select * from c; deptno dname loc ---------- ------------ ------

Oracle rac service addition Process (11gr2) 1. manually add servicesu-oracle [oracle @ dtydb3 ~] $ Srvctl add service-d epmdb-s srv_epm1-r epmdb1-a epmdb2-P basic-e select-m basic-z 180-w 5 2, view service status and PropertiesSys @ EPMDB1 (10.4.124.

Oracle OEM installation and configuration (Common commands) If you use OEM or isqlplus, and do not know the port number, you can find the portlist. ini file; echo % homedrive %Echo % homepath % OEM (9i OCP training materials): OEM composition: OMS

In oracle SQL statements, the use of single and double quotation marks/** double quotation marks in ORACLE "is treated AS a common string **/SELECT '" AS "string result" from dual; /** normally, the strings contained by two ''are treated as the

The basic tutorial on connecting oracle clients to servers is generally like an oracle Server, which has strict requirements on memory and is generally reluctant to install this large program on its own. So in order to avoid the installation of the

Oracle data recovery scenario 2-simulated redo log loss (2) Link: Oracle recovery scenario 1-simulated data file damage or loss http://www.bkjia.com/database/201206/137602.html ; Oracle data recovery scenario 2-simulated redo log loss (1) http://www.