Oracle PL/SQL Category

Quick Search:

Jump to:

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

SQL*Plus Describe - Describe can be used in SQL*Plus to view tables, procedures, functi...

SQL*Plus SQL Prompt - You can change the SQL Prompt. This is very handy when you have s...

SQL*Plus Configuration - How you can show configuration setting.

SQL*Plus connect - Samples of how to connect to the database through SQL*Plus.

SQL*Plus Display commands - SQL*Plus has several important display commands. Here are so...

SQL*Plus formatting - Column formatting in the SQL*Plus application to make reading quer...

SQL*Plus Spool Command - To write the results of a query to a file.

STDDEV - Returns the standard deviation. it returns STDDEV_SAMP if the number of pairs i...

STDDEV_POP - STDDEV_POP computes the population standard deviation and returns the squar...

STDDEV_SAMP - STDDEV_SAMP computes the cumulative sample standard deviation and returns ...

String Functions: ASCII - Returns the ASCII number code that represents the specified ch...

String Functions: CHAR - Returns the character assigned to an ASCII number.

String Functions: CONCAT - Concatenates two or more strings.

String Functions: INITCAP - Makes the first letter of each word upper case.

String Functions: INSTR - Finds the first placement of a character or characters in a string.

String Functions: instring INSTR - The INSTR function returns the location of a substrin...

String Functions: LENGTH - Returns the length of a given string.

String Functions: LOWER - Changes characters to lower case. Numbers remain unchanged.

String Functions: LPAD - The lpad function pads the left-side of a string with a specifi...

String Functions: LTRIM - The ltrim function removes all specified characters from the l...

String Functions: REVERSE - This function reverses the order of the characters in a string.

String Functions: RPAD - The rpad function pads the right-side of a string with a specif...

String Functions: RTRIM - The rtrim function removes all specified characters from the r...

String Functions: SUBSTR - The substr functions allows you to extract a substring from a...

String Functions: UPPER - Makes all characters upper case. Numbers remain unchanged.

SUBST and INSTR together - Using SUBST and INSTR together allow you to do complex extrac...

SUBSTR (SubString) - The SUBSTR functions allow you to extract a substring from a string...

SUM - The function returns the sum, for each node in every argument node-set, of the res...

Switch User - Lets you switch from one database user to another (local database only). ...

Tab Indexes - Returns all indexes and the position of index.