Oracle PL/SQL Category

Quick Search:

Jump to:

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

LAST - Returns the row ranked last using DENSE_RANK.

Last_Day function - The last_day function returns the last day of the month based on a d...

LAST_VALUE - Returns the last value in an ordered set of values. If the last value in th...

LEAD - LEAD provides access to a row at a given physical offset beyond that position.

LEFT JOIN example and syntax - The LEFT JOIN (also called LEFT OUTER JOIN) keyword retur...

LIKE Condition - The LIKE condition allows you to use wildcards in the where clause of a...

List all indexed columns for a given table - Easy way to list all indexed columns for a ...

List analyzed tables with un-analyzed indexes - Sometimes indexes are re-build for perfo...

List security related profile information - List security related profile information.

List supported INIT.ORA parameters - Lists all of the supported INIT.ORA parameters.

List tables with more than 'X' rows - List only tables that have more than 'X' number of...

LOCKS: Table Locking - The basic idea of locking is that when a user modifies data throu...

LOCKS: View Locked Objects - List out all currently locked objects in the database.

Log database errors - Logs all database errors to a table. NOTE: DBA or CREATE ANY T...

Logarithm to base - Returns the log of a number for any base.

Lookup Oracle error messages - Lookup Oracle error messages. Similar to unix "oerr" command.

LOWER function - The lower function converts all letters in the specified string to lowe...

Materialized View - A materialized view is a database object that contains the results o...

MAX - Returns the maximum value by partition.

Measure the Buffer Cache Hit Ratio - Note that hit ratio based tuning is not recommended.

MERGE - One of the most exciting new features addressing the needs for ETL is the SQL st...

MIN - Returns the minimum value by partition.

Modulus - Returns the remainder of y/x.

Months_Between function - The months_between function returns the number of months betwe...

Natural logarithm - Returns the natural log of a number.

Nested Loops: loop through tables - This code demonstrates the use of cursors to loop th...

NTILE - Divides an ordered data set into a number of buckets indicated by expr and assig...

Number Functions: Absolute value - Returns the positive value of a number.

Number Functions: CIEL - Calculates the smallest integer not less than the argument.