Oracle

Today wrote a few hours of SQL statements, at the beginning I did not train of thought, the idea began to write.First I query the storage table in the 3-level units under the various outlets of the storage information, find this information, I went

In Oracle, indexes are basically divided into the following categories:B*tree Index, reverse index, descending index, bitmap index, function index, intermedia full-text index, etc., most commonly used are B*tree index and bitmap index.(1),

OracleFirst, the dataThe DB data fields are as follows:task_id             task_name          t.parent_task_id       ******                       ***                           ***                                 ***000001             t1              

1. Modify the table field type  /* modify the name of the name name_tmp*/ALTER TABLE ca_cadocument rename column cd_taskids to cd_taskids_t; */ Add a field with the same name as the original field name name*/ALTER TABLE ca_cadocument add Cd_taskids

First need to have local Sqlplus command, if not need to download the official website can also click I download (decompression readme.txt has installation configuration instructions):in the Oracle official website Download instant Client for OS X.

The error message that the client gets is usually: Ora-12170:tns: Connection timed outAt this point, we can basically be sure that the server is not open 1521 port (assuming you use the default settings)Workaround:(1) If you are in a LAN environment,

SCOPEThe SCOPE clause lets you specify when the change takes effect. Scope depends on whether your started up the database using a client-side parameter file (pfile) or server parameter file ( SPFile).Scope can specify when changes to the system

The conversion of the old and new platform, need to import the old database data into the new database library, due to different versions, looked up some informationDue to the operational principles of Oracle's IMP/EXP components-backwards

--produce a random number of arbitrary sizeSelect Dbms_random.random from dual;-Generate a random number within 100Select ABS (mod (DBMS_RANDOM.RANDOM,100)) from dual;-Generates a random number between 100~1000Select Trunc (100+dbms_random.value *)

1. Check the primary and standby environmentDG1 node:sql> archive log list;Database Log Mode Archive modeAutomatic Archival EnabledArchive destination/u01/oradata/tong/archiveOldest online log sequence 59Next log sequence to archive 61Current log

In an Oracle RAC environment, use a grid account to performRun asmcmd into ASM command mode, such as:[Email protected] ~]$ AsmcmdAsmcmd>Asmcmd> du//displays all disk space occupied by ASM files in the specified ASM directoryAsmcmd> Ls-ls//Lists the

View Introduction:   views are logical tables that are based on a table or multiple tables or views, and do not contain data in it, which allows you to query and modify the data in the table. The table that the view is based on is called the base

1 CreateType Tabletype is Table of varchar2( the);2 CREATE OR REPLACE FUNCTIONSplit (P_list CLOB, p_sepVARCHAR2:= ',')3 RETURNTabletype4 pipelined5 /**************************************6 * Name:split7 * Author:sean Zhang.8 * date:2012-09-03.9 *

Sql>alter system set log_archive_dest= ' +lwk/archivelog ' scope=spfile sid= ' * ';Then close two instances, launch the instance, change the database to archive mode:Sql>shutdown immediate;Database closed.Database dismounted.ORACLE instance shut

1 --generate a random table2 --CREATE table Scott. One_million as (3 SELECTROWNUM ast_id,4TRUNC (Dbms_random. VALUE (0, -)) Age,5DECODE (Dbms_random. STRING (0,1),6 'A',7 'Zhang',8 'B',9 'Week',

. #!/bin/bashset-xsu-oracle >>eonlsnrctl Startsqlplus/nolog >>eofconn/as SysdbastartupexitEOFexitEONWe often use the [Plain]View Plaincopy Sqlplus EMSSXJK/EMSSXJK Select COUNT (*) from Sncn_yxyj where create_date like sysdate; Eof The SQL

First, Oracle trigger basic SyntaxCREATE[ORREPLACE]TRIGGERTrigger_name{before | After} {INSERT|DELETE|UPDATE[ of column[,column...]]} [OR{INSERT|DELETE|UPDATE[ of column[,column...]]} ...] on[Schema.] table_name | [Schema.] view_name[referencing

--substr (string, intercept start position, intercept length) = return the intercepted wordSelectSubstr'miaoying',0,1) fromDual--The returned result is: MSelectSubstr'miaoying',1,1) fromDual--The returned result is: m--description 0 and 1 both

1. Character functions:ASCII (x)--Returns the ASCII code of the X characterConcat (x, y)--connect Y to output on XSelect Concat (first_name,last_name) from customers;Initcap (x) capitalize the first letter of each word in XINSTR (' NameName ', ' e ',

ORACLE in fact some of the tables due to the increase in traffic, some of the original planning is not very large data volume of the table, in order to optimize the table from the ordinary table into a partitioned table. Now let's introduce a