Oracle

Oracle---------------------------------------SELECT case when T.column_id=1 and T.table_name end table_name, case if T.column_id=1 then T2.comments end Table_ Comments, t.column_id,t.column_name,t1.comments,case when T3. COLUMN_NAME is isn't null

Stored procedures are not used in small companies, but if the business is complex or the performance requirements are more stringent when the stored procedures come in handy, some of the earlier version of Ibatis does not seem to support stored

1. There are four fields in the table: Personnel number, start time, end time, type, data ID, need to implement the following requirementsA. When the type is-1, the record is discardedB. When the type is-1, and the previous line end time is null,

"Oracle Connection string" "Oracle Net Manager Service naming Configuration" "PL/SQL Landing database"Several important parameters to connect to the database:1. Login Username: User;2. Login Password: password;3. The server address (SERVER_IP) and

(1) The concept of table space and partitioned tableTable Space:is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition table:When the amount of data

Transferred from: http://www.cnblogs.com/xwdreamer/p/3511047.htmlReference documentsDocument 1:HTTP://BLOG.ITPUB.NET/24104518/VIEWSPACE-730682, character format, need to clean up a bitLiterature 2:http://www.cnblogs.com/fengyun627/archive/2009/07/27/

SELECT DBF. tablespace_name,      DBF. Totalspace "Total (M)",      DBF. Totalblocks as total block number,      DBF. Totalspace-dfs. FREESPACE "Usage (M)",      DBF. Totalblocks-dfs. Freeblocks as uses blocks,             dfs. FREESPACE "Total

Recently in the use of Oracle, often to import export data, commands are simple, but often forget, so write down.Drop UserYfplssCascade;--log on to the system user to delete the existing user name and everything under that user is deleted.--CREATE

1.rownum:rownum is a pseudo-column that needs to be rownum when the data is taken out, so a nested query is required for paging lookups.SelectSal,ename from (SelectRowNum asRn,sal,ename from (SelectSal,ename fromEmpwhereSal is not NULL Order

1. Table field self-correlation and analysis function performance comparison, self-correlation needs to scan table two times, analysis function scan once can----Self-correlatingSelectV1.proj_id,v1.proj_start,v1.proj_end fromv v1,v

Statements used to capture table structures in Oracle and statements captured in oracleOracle --------------------------------------- SELECT case when t. COLUMN_ID = 1 then t. table_name end table_name, case when t. COLUMN_ID = 1 then t2.comments

Oracle BASICS (4): Single Table query1. Basic Query(1) Basic Statement 1. SyntaxSelect [distinct] * | {Column name...} from table name [where {condition}] 2. Note 1) distinct: whether to remove duplicate data when displaying resultsIndicates that

Oracle Table Partitioning Oracle table partitions are divided into four types: range partitions, hash partitions, list partitions, and composite partitions.   I. Range partitioning Partitions are based on the range of values of a field in the

Guess: the cause of SQLText & quot; ** SQLTextNotAvailable ** & quot; In the Oracleash report Guess: Why "** SQL Text Not Available **" appears in SQL Text in the Oracle ash report The HVR data synchronization software is being tested today. Due to

ORACLE-013: kill deadlock process in oracle In oracle, stored procedures or functions that frequently access packets may cause deadlocks. Scripts of deadlocked objects cannot be run, causing freezing or an exception: too many connections are opened.

Oracle physical storage structureOracle physical storage structure The database is actually composed of a pile of physical files, mainly including four:1. control files)2. Data files (Date files)3. redolog)1. Control File The control file is the

Create split and splitstr functions in Oracle It is recommended that SQL statements be created in sequence.   /*************************************** Name: split * author: sean zhang. * date: 2012-09-03. * function: returns the table type after a

How to install Oracle 11gr2 in OEL5.5, oel5.20.gr2 Virtual Machine environment: Vmware Workstation 11.1.0 + Oracle Enterprise Linux 5.5 X86-641. Physical Machine memory settingsMinimum: 1 GBRecommended: 2 GB or aboveMemory size:# Grep

64-bit win7 Oracle11gR2 Database Installation   I. Description To install the Oracle11gR2 database in the 64-bit Windows 7 operating system, we first need to download the Oracle database software, which contains the 32-bit and 64-bit Oracle database

[Oracle11g auto-increment primary key]Oracle Auto-incrementing primary keys must be implemented using sequences and triggers. First, we create a table where the primary key is int to implement auto-incrementing. CreatetableTEST (ID intPRIMARYKEY,