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.