Oracle

Oracle uses the audit_trail parameter to control whether auditing is enabledThere are several parameters to the Audit_trail:None: Audit not openOS: Description Audit information is put on the system summary, if it is Linux then determined by

The project involved in this article is done on a test machine, which is scaled according to the hardware capabilities of the real project.There is an aviation analysis system, its user volume is about 20, its nature between OLTP and Datawarehouse,

Sql> Select COUNT (*) from V$session #当前的连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Select value from v$parameter where name = ' processes '--the maximum number of connections allowed for the databaseSql> Show

1.Build Library UseAdmin Managedusing policy managed occurs when the instance name of Node 1 is sid_2 in a RAC environment2. Some minor patches if you create a database without using custom, you will need to manually upgrade the data dictionary of

Because the project needs to have a written Java program that wants to be called in a trigger on a table in Oracle so that every time the data is updated, the Java program is called to modify the background data.The process is now documented as

  Go from http://www.cnblogs.com/252e/archive/2012/09/13/2682817.html query and delete duplicate record SQL statement  1, find redundant duplicate record in table, Duplicate records are based on a single field (ID) to determine  select * from table

ORA-54013: Do not allow INSERT operations on virtual columnsThis is a new feature of Oracle 11-Virtual columns.In previous versions of Oracle, when we needed to use expressions or some calculation formulas, we created a database view, and if we

In daily development, it is often necessary to import a. dmp file into a database, below is a brief introduction to how to import from a command1. Create a AWSBPM userCreate user username identified by password;Example: Create user test identified

Existing Oracle Table A table BID COLA ID COLB1 1 2 42 2 3 53 3 4 6Full JOIN operation for table A and table B sql1:select t.id,cola,colb from (SELECT * from A) T fully Join (SELECT * from B) R on T.id=r.idThe result is ID COLA COLB1 12 2 43 3 56

in the Oracle 11g , open Archive Log mode, the default archive directory is db_recovery_file_dest specified. This parameter can be specified in Pfile/spfile:Show Parameter Db_recovery_file_destdb_recovery_file_dest=

If the table structure corresponds to only one field, you can select col1 bulk collect into variable without a cursor loop, simple and efficientCreate or Replace function Get_airway_subpoint (awid in number)Return Airway_subpnts_tab is--create OR

Select User_sequence.nextval Form DualThe above attributes describe:keyproperty= "id": a property in a classOrder: Build Policy: (insert into before or after execution): default is After executionSequence in the User_sequence:oracleTo create a

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/88/A2/wKiom1f91h6z5zPvAABLsY9WlbM240.png "style=" float: none; "title=" QQ picture 20161012141311.png "alt=" Wkiom1f91h6z5zpvaablsy9wlbm240.png "/>650) this.width=650; "src=" Http://s3.51cto.

If you are repeating the installation, you first need to clear the existing software Installation record: Rm-fr/usr/local/bin/*oraenvRm-fr/usr/local/bin/dbhomeRm-fr/usr/tmp/.oraclerm-fr/tmp/.

Client: WIN10Server: Oracle server installed on Linux1, download Plsqldeveloper11.zip, Instantclient_11_2.rar and unzip to the corresponding directoryD:\instantclient_11_2, D:\PLSQL Developer2. Add environment variables on WIN10Variable name:

Mysql differs from Oraclearticle category : databaseReproduced in http://blog.sina.com.cn/s/blog_5d9ca4ea0100kmhy.htmlFriday went to a company to interview, the company manager asked about The difference between Mysql and Oracle has not been summed

Role: Logically treat multiple Oracle databases as a single database, meaning that objects in another database can be manipulated in one databaseSimple syntax:CREATE [public] The DATABASE LINK dblink CONNECT to the user identified by password USING '

To insert data while creating a table:CREATE TABLE Zhang3 as SELECT * from Zhang1;CREATE TABLE Zhang3 (id,name) as SELECT * from Zhang1;Insert the query data into a table:INSERT INTO Zhang3 select * from Zhang1;Insert into Zhang3 (id,name) select *

Things to be aware of when using EXPDP and IMPDP:Exp and IMP are client tool programs that can be used either on the client or on the server side.EXPDP and IMPDP are server-side utilities that can only be used on the Oracle server and not on the

Export the data in the database as an SQL statement:Prompt importingTableOutpadm. CCPC_STROKE_CCPCNCZHZSCPGB ...SetFeedbackoffSetDefineoffInsert into Outpadm. CCPC_STROKE_CCPCNCZHZSCPGB (master_patient_id, Master_bring_count, Master_ccpc_type, JLSJ,