Oracle

Preface: Only follow the master introduction, can take less detours, English documents is the most authoritative learning materials.(1), find the official online documentation for Oracle databaseThe following are the official online documentation

1--first look at which locks are2 Select /*+ Rule*/S.username,3Decode (L.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL) Lock_level,4 O.owner,5 O.object_name,6 O.object_type,7 s.sid,s.serial#,8 s.terminal,9 S.machine,Ten S.program, One S.osuser A

The Select primary key or the column that can represent the current row from (the select Primary KEY or the column that can represent the current row, repeating columns, row_number () over (PARTITION by repeating column ORDER by repeating

This article lists several ways to export data from an Oracle table to a TXT file, currently only three methods are listed, if the subsequent discovery of better methods will continue to be added.1.plsqldev There is an option to put the table in

Recently the Department of testing staff found a problem, said the Oracle user password prompt to expire, ask me what happened?The discovery found that the Oracle user password is only valid for 180 days, communicating with the responsible person

First, the functionFunctions are stored as database objects in an Oracle database, and functions are called PL/SQL subroutines. Oracle processing uses system-provided functions, and users can define their own functions. A function is usually called

1. Create packages (Package)Function:Create or replace package name as functionNote: Multiple functions can be added after asStored procedures:Create or replace package name as stored procedureNote: Multiple stored procedures can be added after as2,

Concept:The logical structure of Oracle can generally be divided into:table Spaces (tablespace), segments (segment), zones (extent), data blocks. Oracle consists of table spaces, which consist of segments, segments composed of blocks, and extents

Create tablespace user3 datafile ' e:\test\user3_data.dbf ' size 20M--Table space Initial Size: 20MAutoextend on next 5M maxsize 50M--auto-grow and 5M per expansion, table space Max is 50M--View table Space storage path and informationSELECT * FROM

This article is intended to instruct project personnel to extract the AWR reports of Oracle databases themselves.1. The AWR report extraction for the current connection instance:@?/rdbms/admin/awrrptSql> @? /RDBMS/admin/awrrpt CurrentInstance~~~~~~~

*********** Importing (exporting) data with toolsTool (T)-"Export Table" (X)Tool (T)-"Export Table" (X)Selected Execution File location:E:\oracle\product\10.2.0\db_1\bin\imp.exe (Exp.exe)********* command Import and ExportOracle Import DMP File

Note the point:1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold section] to execute2. Ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\", which is the path where you want to save the file

The wildcard characters for Oracle, operators are typically present in the WHERE Condition clause: Operator: equals: =, , >=, <> Contains: In, not in, exists, not exists Range: Between...and, not Between....and Match

Oracle cannot import empty table Solution Oracle cannot import empty tables C: \ Users \ Administrator> sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Sunday August 17 19:24:29 2014 Copyright (c) 1982,201 0, Oracle. All rights

Solving ORA-28000: theaccountislocked In oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the account is locked. This

Oracle current row function date Date of use Oracle internal use of digital storage date: century, year, month, day, hour, minute, second. The default date display format is DD-MON-RR. -- Only the last two digits of a year can be specified,

Full-text index-custom chinese_lexer dictionary, Full-text index its data dictionary is originally its own encrypted data format. It can be modified only after it is translated. After this modification, generate its own data format file, overwrite

Typical Oracle database queries This document collects common database queries and requires the database administrator privilege: 1. query temporary tablespace usage SELECT TABLESPACE_NAME, TABLESPACE_SIZE / 1024 / 1024 TABLESPACE_SIZE_MB,

Oracle Automatic Memory parameter dependency The database will only automatically optimize the size of the child components of SGA. The Automatic Optimization of PGA is irrelevant to whether or not to explicitly set the PAG. However, the overall

How to export an Oracle database from a server to a local Oracle Database: oracle Database 1. Import the Oracle database on the server to the local Run the following command in CMD mode: Exp username1/password @ Server database file = Local Hard