Oracle

The index is like the directory of a dictionary. With the dictionary directory, we can find the items we need very quickly. The same is true for databases.　 　With an Oracle database index, related statements can quickly locate the location of a

Analyze index space usage and whether indexes need to be rebuiltAnalysis of indexes under other users requires analyze any permissionsLook at the size of the table and the size of the index before analyzing the index, if the index size is as large

Oracle spatial can easily store spatial data, and large amounts of spatial data must be queried using spatial indexes. Creating a spatial index in Oracle requires that metadata be established before the index can be created. To create the code for

Attention:1. Assign Value: =2. Or the relationship is represented by orDeclarePrefix VARCHAR2 (2); --PrefixRes_value VARCHAR2 (20);BeginPrefix: = ' QZ ';For I in (select Col1,col2 from table_name) loopIf i.col1= ' col1 ' or i.col2= ' col2 '

use of rownum in the result set in Oraclefor Oracle's rownum problem, a lot of data are said not to support >,>=,=,between...and, only with the above symbols (,>=,=,between. and will prompt SQL syntax error, but often do not find a record, but also

Dual is a virtual table that makes up the syntax rules for SELECT, and Oracle guarantees that there will always be only one record in dual. We can use it to do a lot of things.Dual is a virtual table that makes up the syntax rules for SELECT, and

V$datafile is information about data files obtained from Oracle's control filesV$datafile_header is from the head of the data fileUnder normal operation, the checkpoint SCN values for both are consistent, but when the datafile is damaged you can use

1, ready the required installation package, http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html this URL has a variety of operating system

--CREATE table space and database files and default tablespace sizeCreateTablespace tablespace_test datafile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF'size 200m;--set up automatic database growthAlter DatabaseDataFile'E:\ORACLE\PRODUCT\

One: simple test job Create a process case:1 , first create a job_test table, field is a Date FormatSql> CREATE TABLE Job_test (a date);Table createdSql> commit;Commit Complete2 , create a stored procedure BB the effect is toward pig inserting data

1. Data Recovery guide:Quickly detect, analyze, and repair faultsMinimizes downtime and run-time failuresMinimizes disruption to usersUser interface:--em GUI interface (multiple paths)--rman command LineSupported Database configurations:--Single

Ok, that's looks hard, and if you use this procedure I wrote, its really quite easy, it does all of the work for you:Create or Replace procedure Html_email (p_to in Varchar2, P_from in Varchar2, P_subject In Varchar2, p_text in varchar2 default

DblinkWhen we want to access data from another database table across a local database, the local database must create a dblink of the remote database, and the local database can access the data in the Remote database table as if it were accessing

Change Oracle from archive mode to non-archive modeStart –> Run command cmd into command line mode1. Use the command Sqlplus to open the following form without logging:Sqlplus/nolog;2. Connect to the database Dev.world where Dev is the Oracle SID is

1. Show Dname and Loc intermediate-delimitedSelect Dname | | ' -' | | Loc from Dept;2. Fill the department name to the left as 10 bitsSelect Lpad (dname,10) from dept;3. Replace the employee name's ' s ' with ' s 'Select replace (ename, ' s ', ' s ')

These days using PowerDesigner to build a library, general database exported SQL build table statements with "" double quotation marks, resulting in my library table names are lowercase, but the Oracle query and other statements by default are

I. Data types in Oracle1, String type. such as: char, nchar, VARCHAR2, nvarchar2.2, numeric type. such as: int, number (p,s), Integer, smallint.3. Type of date. such as: date, interval, timestamp.4. PL/SQL type. such as: Pls_integer, Binary_integer,

After you create a new connection server on SQL ServerExecutes the specified pass-through query on the specified linked server.The server is an OLE DB data source.OPENQUERY can be referenced in the FROM clause of a query as if it were a table name.

PROC simple use case -- connect ORACLE with VC Operating System: windows 7 Database Version: oracle 10g VS version: VS2010 There are many ways to connect to ORACLE. Here, we only use PROC as an example to explain how to connect to oracle. What's

Grouping functions of oracle reinforcement exercises 1. Show jobs with an average salary of> 2000 Select job, avg (sal) from emp group by job having avg (sal)> 2500; 2. Calculate the average salary of over 2000 jobs and the average salary of over 300