Oracle PL/SQL Category

Quick Search:

Jump to:

To view the original pages (which were formerly called "Morgan's Library"), you can click here.

INDEXES: Rebuild Reverse - REVERSE stores the bytes of the index block in reverse order ...

INDEXES: Reverse Key Indexes - Creating a reverse key index, compared to a standard inde...

INDEXES: Single Column Non-unique - Example of creating an index. Note that by default, ...

INDEXES: SORT and NOSORT - When creating an index, the default method Oracle uses to sor...

INDEXES: Unique indexes - Using constraints is preferred to using triggers, rules, and d...

INDEXES: View table indexes - Examples of viewing the indexes on an Oracle table. Replac...

INDEXES: Virtual / NoSegment - Virtual Indexes are another undocumented feature used by ...

InitCap - InitCap sets the first character in each word to uppercase and the rest to low...

INNER JOIN example and syntax - The INNER JOIN keyword return rows when there is at leas...

INSERT - Examples of INSERT statements.

INSERT ALL - You can use the INSERT ALL statement without a condition. This provides you...

INSERT ALL WHEN - If you specify ALL, the default value, then the database evaluates eac...

INSERT FIRST WHEN - The WHEN clause is evaluated in the order in which it appears in the...

INSERT WHEN - The insert when command can do a conditional insert. There are 2 modes...

INSERT WITH CHECK OPTION - The "WITH CHECK OPTION" is used to indicate that Oracle will ...

INSERT With Returning Clause - The RETURNING clause was implemented as part of the Oracl...

INSERT with Select - Basic Insert with Select example with a subquery.

INSERT: Single Column Table Or View - Simple single table/column SELECT examples.

INSERT: Using A Record - Insert by Using RECORD Type Variable.

Inserting into SELECT statement - You can use a select-statement within an INSERT statem...

Instant Test Database with DCBA - DBCA is what you need to create a test database in onl...

INSTR (InString) - The instr function returns the location of a substring in a string. ...

IS NOT NULL - In PLSQL to check if a value is not null, you must use the "IS NOT NULL" s...

Job Queue - Returns currently running jobs.

Kill Dupes- "Shoot On Sight" - Absolutely, positively removes duplicate records from a g...

Kill Session - With the proper privileges you can kill any active session.

LAG - LAG provides access to more than one row of a table at the same time without a sel...

Lag Report - A sample of a payment lag report.