Term: IS

Definition:
The Oracle PL/SQL IS keyword appears in the subprogram definitions of both procedures and functions. It logically unites the header and declarative part of a subprogram. AS is an alias keyword which can be used in place of IS.

Example Usage:

CREATE OR REPLACE PROCEDURE P_SAL

IS

BEGIN

...

...

END;

CREATE OR REPLACE FUNCTION F_SAL

RETURN NUMBER 

IS

BEGIN

...

...

END;

• Wage and Commission Calculation - This block calculates the total wages (salary plus commission) ...
• Frequency Distribution - Returns the frequency of a a given value in a set of values.
• EXISTS - Sample of the use of 'EXISTS' clause in SQL
• EXISTS 2 - Another example of the use of the 'EXISTS' clause.
• CUME_DIST - Returns the cumulative distribution of a value in a group of values.
• PERCENTILE_DISC - An inverse distribution function that assumes a discrete distribution model. It ...
• List analyzed tables with un-analyzed indexes - Sometimes indexes are re-build for performance and...
• List all indexed columns for a given table - Easy way to list all indexed columns for a given table.
• List security related profile information - List security related profile information.
• Display database SGA statistics - Handy routine to display the database's SGA statistics.
• List supported INIT.ORA parameters - Lists all of the supported INIT.ORA parameters.
• Display locks and latches - Display database locks and latches (with tables names, etc).
• Display and release DBMS_LOCK locks - Release DBMS_LOCK locks on database.
• List tables with more than 'X' rows - List only tables that have more than 'X' number of rows.
• TIMESTAMP: List time zones - Produces a list of valid timezones.
• ASCIISTR - ASCIISTR takes as its argument a string, or an expression that resolves to a string, in...
• UNISTR - Takes a text literal (or an expression that resolves to character data) and returns it in...
• SELECT: Get UNIQUE / DISTINCT values - The DISTINCT command retrieves only unique data entries dep...
• SELECT: Get DISTINCT / UNIQUE values - The UNIQUE command retrieves only unique data entries depen...
• SQL*Plus Display commands - SQL*Plus has several important display commands. Here are some examples.
• Distinct - The DISTINCT clause allows you to remove duplicates from the result set. The DISTINCT c...
• IS NOT NULL - In PLSQL to check if a value is not null, you must use the "IS NOT NULL" syntax.
• USER - misc queries and commands - Some user related queries and commands.
• INDEXES: Compute Statistics - When an index has no statistics, Oracle9i and earlier will neither s...
• INDEXES: DISABLE (function-based index) - DISABLE is only applicable (valid) for function-based...