Oracle

Reprint to: http://blog.itpub.net/29378313/viewspace-1064069/For the sake of convenience, the following simple models are established and some test data are constructed:In a business admissibility subsystem BSS,SQL Code --customer data

Oracle Delete FOREIGN KEY constraint disable constraint enable constraintExecute the following SQL-generated statementDelete all foreign KEY constraintsSQL codeSelect ' '| | table_name| | ' '| | Constraint_name| | ' ; ' from where constraint_type=

Permissions:Create sessionCREATE tableUnlimited tablespaceConnectResourceDbaCases:#sqlplus/nologSql> Conn/as sysdba;Sql>create user username identified by passwordSql> Grant DBA to username;Sql> Conn Username/passwordSql> select * from

Database index:The index has a single-column index, and the composite index says that if a field of a table has a PRIMARY KEY constraint and a uniqueness constraint, Oracle automatically suggests a unique index on the corresponding constraint column.

Wrote a program: read a table in SQL Server based on the status bit, download the value of one of the fields, this value is XML type, then insert the contents of the XML file into another Oracle database, and update the SQL Server table flag,

The main is to summarize the Oracle functions used in the project, and make a directory, so that the follow-up project is quick to find and improve efficiency.01.Round (rounding of values)Description: Returns a numeric value that is the result of

View SQL statements for Oracle statusSelect status from V$instance;View SQL statements for Oracle control filesSelect name from V$controlfile;View SQL statements for Oracle data filesSelect name from V$datafile;View Oracle Online log filesSELECT *

error when connecting with Visualizer: Error encountered while performing the requested operation: IO error: The Network Adapter could not establish the connection1 Use the Cclear or LU master and other registry cleanup tools to clean up after the

Although the use of many times impexp and IMPDPEXPDP but still encounter a lot of problems, now summarized as follows:Application:Import all table structures and indexes, triggers, procedures, functions, etc. of a user into another userIMP/EXP

This script first finds the index that the user failed to connect to and rebuilds it online.Create or replace procedure Index_rebuild asCursor Mycur isSELECT *From User_indexeswhere status = ' unusable ';Myrec User_indexes%rowtype;Vsql varchar (100);

Open the graphical window:1) Database Configuration Assistant windows (add DB Instance)$ dbca2) Oracle Net configuration Assistant windows (Configure listening)$ netca3) Open EM$ Oemapp Dbastudio (Open Enterprise Manager graphical interface)$

This document implements the target AIX tablespace: ITDB mode: Capacity expansion scheme for bare devices Author: johncoco Date: 2016/1/291. Query the raw device files used by Oracle database tablespace ITDB , note the bare device files (starting

1.rownum and sortThe rownum in Oracle is the sequence number that is generated when fetching data, so it is important to be aware of the rowmun rows of data that you want to specify for the sorted data.Sql> Select RowNum, id,name from student order

This article mainly introduces the use of RowNum and Row_number () in Oracle, as well as the differences and links, very detailed, the need for small partners can refer to.Row_number () over (partition by col1 ORDER by col2) indicates that,

In the production system, due to business needs, 56 tables are emptied of 54 table data, the other two table data retention, the amount of data about 10G:1. Most people think is EXPDP/IMPDP, it is true, haha2.rman3. The following method, moveThe

Views and synonyms are the names of objects in the database, each of which does not correspond to the actual data store , and is dependent on the existence of other objects.Views: Views can be viewed as virtual tables or stored queries. Unless it

http://blog.csdn.net/yuzhic/article/details/1896878http://blog.csdn.net/macle2010/article/details/5980965This command uses a single statement to complete updating and inserting data from one or more data sources to the table. Oracle 9i, using this

--Time: January 27, 2016--author:zhenxing Yu--Query Recycle BinSELECT * from RecycleBin;SELECT * from User_recyclebin; --user_recyclebing and RecycleBin are synonyms, the fields are exactly the same--Turn the Recycle Bin on or off--A: Session level

Variable Length array in oracle varray, nested table, set usage, oraclevarray Create a variable-length Array CREATE TYPE varray_type AS VARRAY(2) OF VARCHAR2(50); This variable-length array can accommodate up to two data types: varchar2 (50) Change

Two methods for creating Database Link in Oracle are described in detail. Create A dblink named dblink_name, which is connected from database A to database B. Database B has the IP address 192.168.1.73, port 1521, Instance name oracle, login name