Oracle

In oralce, query the lock table records and unlock the tables that are locked first. select B. owner, B. object_name,. session_id,. locked_modefrom v $ locked_object a, dba_objects bwhere B. object_id =. object_id; query the sid and serial of the

Oracle truncate table Truncate is a SQL statement used to delete data TABLE content: syntax truncate table name parameter name is the name of the TABLE to be truncated or the name of the TABLE to delete all its rows. The following describes the

Oracle over partition by select * from test data: a B c 1 1 1 1 2 2 3 3 2 5 3 4 6 --- add the corresponding C column values with the same B column values to the total select a, B, c, SUM (C) OVER (partition by B) c_Sumfrom test a B C C_SUM 1 1 1 1 1

The oracle produce synchronization intermediate database is used as an Internet system on an existing system. Considering the server pressure or the absence of conditions, it can directly connect to the database of an existing system. You need to

Sort the query results according to the in content. Today, the customer sends an excel table with a small amount of content. There are two columns: the license plate number and the device number, let me help export the information about the device

Oracle scott user Default table EMP (employee table) NO field type description 1 empno number (4) employee NUMBER 2 ENAME VARCHAR2 (10) employee name 3 JOB VARCHAR2 (9) job position 4 mgr number (4) represents an employee's lead NUMBER 5 hiredate

ORA-28001: the password has expired scott/tiger solved today when using oracle 11, using the default account scott login in sqlplus, found an error, could not solve this problem: 1, the account scott is in the unlocked status. -- Of course, he will

Three Data Guard Modes: Data Guard Protection mode (Data Guard Protection Modes) for Data Guard, its survival logic is very simple, because it provides three Data Protection Modes, we call it another kind: There are three models: Maximum protection:

Oracle Database SQL single-row function-TRIM function of the character function can remove spaces of strings. For example: [SQL] select TRIM ('s 'from 'ssmith') from emp; -- delete the specified character and the result is: mith select trim ('oralce

To install oracle in win7, You need to modify the configuration items. 1. Set the fixed ip address, set the installation program compatibility (windows XP Sp3), and run it as an administrator. 2. Add the following to database \ stage \ prereq \ db \

Example of the change in the initial value when the parameter compress = y in EXP causes imp: Import/Export version, platform: 11.2, windows import/export version, platform: 10.2, linux 1. create a test table: [SQL] SQL> conn scott/xyc is connected.

How to format the output set linesize 180 set pages 999 set long 90000 of the dbms_metadata.get_ddl stored procedure -- set the line feed col a for a200 wrapped word -- select dbms_metadata.get_ddl ('index ', 'I _ dj_nsxx_djjg_dm', 'hx _ dj') a from

Write a script to start the database. Every time you open Linux, you always need to write duplicate operations. That is, start the listener, start the database, and view the database status. It is more convenient to write a shell script to control

Oracle knowledge point summary (1) architecture: the database architecture refers to the composition, working process and principles of the database, and the organization and management mechanism of data in the database. The architecture includes:

Oracle GoldenGate series: Extract process Recovery principles BR applicable to Extract processes (only applicable to Oracle databases) use the BR parameter to control the Bounded Recovery (BR) function of GoldenGate. The Bounded Recovery function

Export excel create or replace directory MY_DIR as 'C:/abc' in oracle; create or replace procedure export_data_out_excel/** use utl_file to write the data to the text file pfile_name: output file name. Pexport_ SQL: The executed SQL statement,

Oracle TNS-04415 ErrorSaturday, March 30, 2013Error descriptionD: \ Users \ Elvis> netcaOracle Net Services Configuration:Configuring LISTENER: LISTENERServiceAliasException: unable to save service alias: TNS-04415: file I/O ErrorCaused by: java. io.

Oracle tablespace (II)-view tablespace usage SQL code SELECT UPPER (F. TABLESPACE_NAME) "tablespace name", D. TOT_GROOTTE_MB "tablespace size (M)", D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M)", TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F.

Oracle deletes, adds, and modifies multiple fields to create a table: SQL> create Table t (a number); table created SQL> desc t; name Type Nullable Default Comments ---- ------ -------- ------- -------- add multiple fields SQL> alter table t add (B

Use of some built-in methods in oracle 1. query a tablespace in a database: Use select * from DBA_INDEXES or DBA_OBJECTS 2. query database connections: select count (*) from V $ SESSION 3. query the maximum number of connections in the database: