Oracle

First, IntroductionORACLE provides the ability to PL/SQL The program is stored in the database and can be run anywhere. This is called a stored procedure or function . Procedures and functions are collectively known as PL/SQL subroutines, which are

Directly on the SQL code:Declare begin forCinch(SelectS_personinfo.nextval asSeq fromdual) LoopInsert intoTbpersoninfo (Ipersoninfoid,vcpersoncard,vcpassword,vcpersonname,vcpersionsex)Values(C.seq,'33000021','123456','Xiao Ming','male',); ifC.

--Create the user created (username is wpip, password is WPIP) create username Wpip identified by wpip default tablespace pipdb_dat1 temporary tab Lespace TEMP profile DEFAULT;--Grant/revoke role privileges (grant to user Wpip Connect, DBA, resource

There is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.Workaround:1) Insert a row, and then rollback will produce segment.The method is to insert data into the empty table and then delete it,

Many times, we do a small batch of data migration will use the data pump, but 12C we want to configure TNS to specify the PDB import, but the public service we are through the cluster using SRVCTL to create. At this time preferred instances may have

With...as ... Statement is used to define a query statement as a name and can then be referenced in subsequent query blocks. The query block with definition has a high priority when the query name repeats with the existing table name. The WITH

1.oracle View OperationsCreating view: Create view name as query data;Delete view: Drop view name;Cases:CREATE VIEW MyView as SELECT * fromTest_person;(You can modify the view, the modified data will affect the base table)CREATE VIEW MyView as

[Email protected] ~]$ Ps-ef|grep SmonOracle 14809 1 0 Sep25? 00:13:02 ORA_SMON_MAILP3[Email protected] ~]$ export ORACLE_SID=MAILP3[Email protected] ~]$ echo $ORACLE _sidMailp3[Email protected] ~]$ Sqlplus/as sysdba;Sql*plus:release 11.2.0.3.0

I. The role OF triggersA trigger acts like an interceptor. Intercept some DML operations (Insert/update/delete/select) against the database and operate in accordance with business requirements, and non-conforming operations can be prevented by

Attempt to load Oracle client libraries threw badimageformatexception. This problem would occur when running in a bit mode with the-the-bit Oracle client components installed. ---> system.badimageformatexception: An attempt was made to load an

1. First we can log in to Oracle as SYSDBA as a Scott user.Conn Scott/ as Sysdba 2. Then I'll be able to create the user.Create User by 123; 3. Create a good user we can then modify the user's password.Alter User by Chen; 4. By default, the

Syntax: Row_number () Over (PARTITION by column ORDER by column)In a nutshell, Row_number () returns a number for each grouped record starting at 1, where Row_number () over (order by XLH DESC) returns an ordinal of the XLH column in descending

Decode () function Introduction: main role: Translating query results to other valuesHow to use:Select decode (ColumnName, value 1, translation value 1, value 2, translation value 2,... Value n, translation value n, default value)From TalbenameWhere

I. Smon: System monitoring Process1. Mainly submitted data but has not yet been written to the data file to power down, restart the time, the Smon will be restoredA. Roll forward, the redo log file has been written but no data has been written to

Export can be understood as setting environment variables in the Linux bash. Can be used by the current shell and child shell.The meanings of these variables are somewhat meaningful and you can view the corresponding documents, and I'll explain to

DatabaseListener.ora# Listener.ora Network Configuration file:c:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener = (sid_list = ( Sid_desc = (sid_name = Clrextproc)

1. Equivalent connection: Take the same record as the relationship columnSELECT * from emp e,dept d where E.deptno=d.deptno;Find the same records as the Deptno column in the EMP and dept tables2, non-equivalent connection: Take a record of the

When Oracle performs some DML operations, it has the flag of the active transaction on the Oracle block, if a transaction commits, because some blocks have been written back to DataFile before commit, or if the transaction affects too many blocks,

1. Login: sqlplus/@orcl as Sysdba2. Snapshot: Exec dbms_workload_repository.create_snapshot3.AWR report: @ $ORACLE _home/rdbms/admin/awrrpt.sqlIf you don't set Oracle_home, you'll find the exact

Reproduced for individual study reference, please visit the original source: http://www.cnblogs.com/upDOoGIS/archive/2009/05/20/1469871.htmlrelated micro-blog: Oracle Create sdo_geometry tableThere are several ways to store data from SDE storage in