Oracle

1. Use the following SQL statement to query the session_id and username of the process that caused the lock table to be improperly operatedSELECT S.sid session_id, S.username, DECODE (lmode, 0, ' None ', 1, ' Null ', 2, ' Row-s (SS) ', 3, ' Row-x

1. Querying for locks in the databaseSELECT * from V$lock;SELECT * from V$lock where block=1;2. Querying for Locked objectsSELECT * from V$locked_object;3. Query blockingCheck for blocked sessionsSELECT * from V$lock where lmode=0 and type in (' TM '

Select column_name, case when data_type = ' number ' ThenData_type | |' (' || NVL(To_char (data_precision),' * ') || ', ' || NVL(To_char (Data_scale),0) || ' ) '           whendata_typeinch (' VARCHAR2 ', ' CHAR ') ThenData_type | | ' ('

First, write a cmd script xx.cmdsqlldr username/password control=xx.ctl errors=10000000 direct=yWrite a bat script again Xx.bat servicename is generally ORCLsqlplus username/password@serviceNameTo load the SQLcall xx.cmdsqlplus

The Oracle Intercept character (SUBSTR), which retrieves the character position (instr), when the then else End statement uses the favoriteCommon functions: Substr and InStr1.SUBSTR (String,start_position,[length]) to substring, return

Relational model E-r model Paradigm 1. Brief description of OracleOracle is a powerful database software developed by 1977 IBM.2. Basic theory of relational data relational database and database management system 1)

--1 Data Environment PreparationEmp,dept table below for Scott users--2 requirements: The highest average wage department number, department name, department average salarySelect D.deptno,d.dname,e.salFromSelect AVG (SAL) Sal,deptnoFrom EMP EGROUP

1 ago time for a new company, work has been very busy, there is no time to summarize!For a few knowledge points simply do the following summary:1 Use of bound variables:1) use several times, in the later using to declare several times, the order of

#路径名, specify the path to the backup filepath=/home/oracle/bachup# the backup database file name filename= ' Date +%y%m%d ' #切换至指定路径 and create a folder CD $FILEPATH based on the specified date format # Export database using exp Here you can use

DeclareCNT integer;BeginSelect COUNT (0)Into CNTFrom User_all_tablesWHERE table_name = UPPER (' dps_biztypes_manage ');If cnt = 0 ThenExecute immediate ' CREATE TABLE Dps_biztypes_manage(Id Integer NOT NULL,BizType VARCHAR2 (4) NOT NULL,Bizname

Common Oracle Query statements1. No order by ordering. (Highest efficiency)After testing, this method is the lowest cost, nesting only one layer, the fastest! Even if the amount of data queried is large, and almost unaffected, the speed remains!The

CmdRun the cmd command lineInput sqlplus/nolog no user name loginConn/as SYSDBA Connect to data Local dataAlter user system identified by password; Modify the system password to passwordor open the Sqlplus software:Window User

When our computer and Oracle code is inconsistent, there may be a Chinese garbled problem, when we just change the CMD encoding to be consistent with Oracle(The SQL Plus interface displays garbled characters)(Change the CMD code to UTF8 after the

To create a table and add data:--Create Table_aCreate Tabletable_a (Avarchar2(Ten), Bvarchar2(Ten) );--add data to Table_aInsert intoTable_aValues('A1','B1'); Insert intoTable_aValues('A2','B2'); Insert intoTable_aValues('A3','B3'); --Create

VS2015 when connecting to Oracle, it must be installed in a directory that does not contain spaces, otherwise it is not connected to Oracle, as for why, do not know, ghost know, Day.If you unfortunately previously installed the VS2015, installed in

Today in the SOA application database using the Dbms_redefition package for the online non-partitioned table conversion partition table operation, I would like to drop off the temporary table cube_scope_temp accidentally forgot to add "temp"

In order to further the left outer connection, we do some testing, the wording of the outer join has several forms, we can trace through 10053 to finally the form of SQL conversion.--Initialize dataCREATE TABLE A(ID number,Age Number);CREATE TABLE B(

There are several ways to insert data, here's a brief introduction to three types1. General Insert DataSelect * from EMP; -- -Scott.emp table as an example -- --Insert data according to values(1122, ' Steve ', ' Workers ', 2233,to_date (' 2017-01-03

1. How to log into Oracle databaseLog in using the Sqlplus command under Linux. For example, the Sqlplus/as sysdba sqlplus command is only available to Oracle installation users, and if you use Sqlplus with another user, an error command cannot be

Because of the trouble of installing the Oracle database today, because of the long-term lack of oracle, we started to consolidate the Oracle knowledge that we learned before.1. Oracle Database: Client/database server using oracle10gORACLE10G can