Oracle SQL Code

	Remove Leading Zero's from a String
	How to return errors when converting floating numbers
	Find exact years and days between 2 dates
	Find years of service of an employee
	Rename a column in a Table
	Drop a column from a Table
	Select the last Saturday in every month
	Performing Case Insensitive Searching
	Limit number of objects created by a user
	Select 6 random numbers between 1 and 49
	Centralising Data in a Column
	Compare 2 Strings
	Creating VARRAYS
	Drop a column clause
	Drop all empty tables
	Find out who is using the TEMP tablespace
	Find data entered yesterday from a date column
	Find LAST_ANALYZED date in Oracle7
	Find spaces in Oracle Scripts
	Display multi line errors in Forms
	How to recreate indexes
	Ordering numerically in a VARCHAR2 column
	Populating VARRAYS
	Running totals with SQL
	Selecting only the group with MAX sum in the query
	Selecting VARRAYS
	Setting SQL prompt to the current directory
	Get tablespace information
	Using BTITLE and TTITLE
	Find out which Oracle Version is installed on Unix