CoderZone.org

 Category: Oracle PL/SQL

Bookmark and Share

Calculate Pi - Returns pi to 14 decimal places.
CAST - CAST converts one built-in datatype or collection-typed value into another built-in datatype or collecti...
CHARTOROWID - CHARTOROWID converts a value from CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to ROWID datatype....
Check Constraint - Create - A check constraint allows you to specify a condition on a column in a table.
CLUSTER_ID - CLUSTER_ID returns the cluster identifier of the predicted cluster with the highest probability fo...
CLUSTER_PROBABILITY - CLUSTER_PROBABILITY returns a measure of the degree of confidence of membership of an inp...
CLUSTER_SET - CLUSTER_SET returns a varray of objects containing all possible clusters that a given row belongs...
Combining the AND and OR Conditions - The AND and OR conditions can be combined in a single SQL statement. It c...
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 string) in any datatype, ...
Compressed Direct Load - Use this clause to instruct the database whether to compress data segments to reduce d...
Compressed Indexes - Oracle introduced a compression option for indexes in Oracle 8.1. You can create an index ...
Compressed Tablespace - Use this clause to instruct the database whether to compress data segments to reduce ...
Compressed Tablespace - Use this clause to instruct the database whether to compress data segments to reduce di...
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.
Connecting to an Oracle database with PHP - This code connects to an Oracle database defined by TNSNAME, using ...
Constraint Checks - A check constraint allows you to specify a condition on each row in a table. A check con...
Control File - The control file contains data on system structures, log status, transaction numbers, and other ...
CONVERT - Converts a character string from one character set to another. The datatype of the returned value is ...
Convert between Decimal, Binary, Octal and Hex - This one will solve a lot of your problems. :) Examples: s...
Convert Hex to Decimal, Decimal to Hex - Functions to convert Hex to Decimal Example usage: select hex2dec(...
Convert LONGs to LOBs - Converts LONG datatypes to LOBs. You can also use the same procedure to convert LONG RA...
Convert text to soundex - Converts a string of text into separate soundex values. Treating it as space delimit...
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 "enter" to continue or "CT...
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 expr1 and expr2 are nume...
COVAR_SAMP - COVAR_SAMP returns the sample covariance of a set of number pairs. Both expr1 and expr2 are numeri...
Create Database Link - A database link is a schema object in one database that enables you to access objects on...

© coderzone.org | users online: 4