Oracle

(1) Initialization of passwordSYS Change_on_intallSystem ManagerScott Tiger(2) Copy a tableCREATE TABLE new_table as (SELECT * from old_table)(3) Modify the primary key of a tableALTER TABLE tablename DROP constraint a_pk;//Delete original PRIMARY

Setting set ORACLE_SID=ORCL orcl--Instance Name --Stop Oracle Instance Services C:\users\administrator>net Stop ORACLESERVICEORCL The ORACLESERVICEORCL service is stopping ... The ORACLESERVICEORCL service has stopped successfully. --Start the

See this interface, I believe a lot of people will like, this interface is very concise, there is no superfluous things, I think the day-to-day operation can basically meet the requirements of the operation of the database is very convenient, I

Sequence: A database object provided by Oacle to produce a series of unique digits. L provide a unique numeric value automatically L Shared objects L primarily used to provide primary key values L Loading sequence values into memory can improve

use of functions and cursors in Oracle --Creates a function and invokes the CREATE function fun1 (v_in_ename varchar2) return number is v_annual_sal number; Begin Select (SAL+NVL (comm,0)) *13 into V_annual_sal from EMP where

1: First you need to create a package and define the type of cursor you return, the stored procedure Create or Replace package test_pkg is--Public type declarationsType cur_emp is REF CURSOR;Procedure Test_proc (v_empno in number, emps out cur_emp);

In the oracle8i version, Oracle has introduced a new way of tablespace management: a localized managed table space.Localized management means that Oracle no longer uses the data dictionary table to record the usage of the area inside the Oracle

--oracle exception return complete information, see finally attached--Of course, it's best to select the returned information, along with other relevant information about the code--such as the occurrence of object name, time, etc. insert pre-built

Oracle Temporary table Knowledge In Oracle, temporary tables are divided into sessions, transaction two, and the session-level temporary table data exists throughout the sessions until the end of sessions; Temporary table data at the transaction

In Oracle, blocking and blocking are frequently encountered. There are several main ways to find blocking and blocking:I. By looking for V$lock and V$locked_objectThis is the most common and direct method. Sql> Select Sid,block from V$lock where

Oracle Partition Partition Detailed summary This article from the following aspects to collate the concept and operation of the partition table:         1. Table space and the concept of partitioned tables         2. Table partitioning specific

Oracle Query optimization 1> Select the most efficient table name order: Put a table with fewer records on the last side of the FROM clause. 2. If there are more than 3 table join queries, then you need to select the Crosstab table (intersection

Today, using the laptop's Plsql developer to connect to Oracle on another desktop in the LAN, the login process is slow, and then reports Ora-12170:tns occurred: Connection timeout Such a mistake, Baidu a long time to find a solution. It is said

---create a tableCREATE TABLE TestTable(ID1 VARCHAR2 (12),Name VARCHAR2 (32))Select T.id1,t.name from TestTable tInsert into TestTable (ID1, NAME)VALUES (' 1 ', ' Zhangsan ');Insert into TestTable (ID1, NAME)VALUES (' 2 ', ' Lisi ');Insert into

--composite index, also known as Union Index, combined index. In Oracle, you can create a composite index, which is an index that contains two or more columns at the same time. Oracle has the following features with regard to the use of composite

CREATE USER "NewUser" identified by "NewUser"DEFAULT tablespace Crm_dataTemporary tablespace TEMPAccount UNLOCK; Today, I created a user named NewUser on the oracle10g, but logged in normal state, always prompting for unsuccessful login, username

As the saying goes, the user is God, they sometimes ask a question very simple, just need a word, a minute will be done, but to our DBA, it may be at least half an hour or even half a month to meet his words, there is a better and faster way, I tell

Guide: When MyEclipse Database Explorer establishes an Oracle DB connection, the following error will be reported regardless of which Oracle JDBC driver package (Classes12.jar,ojdbc14.jar) is used. Java.sql.sqlexception:ora-00604:error occurred at

This is a header file with Otlv4.h, (Master package good, you can use it directly to the Oracle database), check for a long time, the network said a lot of information is not complete, I think we should make some contribution, I write down the

Oracle partition table, partition index Oracle for partitioned table way is actually to partition table, general table is a section of storage, and partition table will be divided into segments, so find the data process is to locate according to the