Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
Oracle PL/SQL Category
Jump to:
Select a Location
PSOUG Home Page
Oracle Code Library
mySQL Code Library
PHP Code Library
JavaScript Code Library
Oracle Terms & Definitions
Oracle Error Codes
PSOUG Community Blogs
Oracle Jobs Board
PSOUG Forum
Oracle User Group Directory
Free Oracle Magazines
Online Learning Center
PSOUG Presentations
Advanced Code Search
News and Events
Sponsors Page
Submit Code
Contact Us
To view the original pages (which were formerly called "
Morgan's Library
"), you can click
here
.
<<
<
1
2
3
4
5
6
7
8
9
10
>
>>
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.
<<
<
1
2
3
4
5
6
7
8
9
10
>
>>
Home
:
Code Library
:
Sponsors
:
Privacy
:
Terms of Use
:
Contact Us
31 users online © 2009 psoug.org
PSOUG LOGIN
Username:
Password:
Forgot your password?