Oracle PL/SQL Category

Quick Search:


	CODE Oracle PL/SQL Code Library


	FORUM Oracle Discussion & Chat

Jump to:

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

Calculate Pi - Returns pi to 14 decimal places.

CAST - CAST converts one built-in datatype or collection-typed value into another built-...

CHARTOROWID - CHARTOROWID converts a value from CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data...

Check Constraint - Create - A check constraint allows you to specify a condition on a co...

CLUSTER_ID - CLUSTER_ID returns the cluster identifier of the predicted cluster with the...

CLUSTER_PROBABILITY - CLUSTER_PROBABILITY returns a measure of the degree of confidence ...

CLUSTER_SET - CLUSTER_SET returns a varray of objects containing all possible clusters t...

Combining the AND and OR Conditions - The AND and OR conditions can be combined in a sin...

Comment an operator - Create a comment for a user-defined operator.

COMPOSE - COMPOSE takes as its argument a string (or an expression that resolves to a st...

Compressed Direct Load - Use this clause to instruct the database whether to compress da...

Compressed Indexes - Oracle introduced a compression option for indexes in Oracle 8.1. Y...

Compressed Tablespace - Use this clause to instruct the database whether to compress d...

Compressed Tablespace - Use this clause to instruct the database whether to compress dat...

Compute Table Size - Compute the overall space used by a given table (in bytes).

Concatenate || - The || operator allows you to concatenate 2 or more strings together.

Constraint Checks - A check constraint allows you to specify a condition on each row in ...

Control File - The control file contains data on system structures, log status, transact...

CONVERT - Converts a character string from one character set to another. The datatype of...

Convert between Decimal, Binary, Octal and Hex - This one will solve a lot of your probl...

Convert Hex to Decimal, Decimal to Hex - Functions to convert Hex to Decimal Example ...

Convert LONGs to LOBs - Converts LONG datatypes to LOBs. You can also use the same proce...

Convert text to soundex - Converts a string of text into separate soundex values. Treat...

Converting Rows to Columns - Easy ways to convert rows to columns in Oracle PL/SQL.

Count Objects - This script: Echoes how many objects will be dropped by type. Type "en...

Count rows in all tables - Count the number of rows for ALL tables in current schema.

COVAR_POP - COVAR_POP returns the population covariance of a set of number pairs. Both e...

COVAR_SAMP - COVAR_SAMP returns the sample covariance of a set of number pairs. Both exp...

Create Database Link - A database link is a schema object in one database that enables y...

Create DB Link - Shows how to create a link to another oracle database and connect to it.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us