Basic Oracle SQL

Home CREATE ALTER DROP RENAME TRUNCATE INSERT UPDATE DELETE SELECT COMMIT ROLLBACK SAVEPOINT GRANT REVOKE ALIASES LITERALS ARITHMETIC OPERATORS CONCATENATION OPERATOR DISTINCT WHERE CLAUSE ORDER BY GROUP BY HAVING COMPARISON OPERATORS AND(&) OPERATOR OR OPERATOR NOT OPERATOR BETWEEN...AND... OPERATOR IN/NOT IN OPERATOR IS NULL OPERATOR LIKE OPERATOR		Home ANY & ALL Number Varchar2 Char Date Lower Function Upper Function Initcap Function Concat Function Substr Function Instr Function Length Function Lpad Function Rpad Function Ltrim Function Rtrim Function Trim Function CHR Function Replace Function Translate Function Round Function Trunc Function Cell Function Floor Function Mod Function Power Function Sqrt Function Sign Function ABS Function SYSDATE Function ADD_MONTHS Function GREATEST FUNCTION		Home Adding Column in a Table Modify Column in a Table Drop Column in a Table Connect By Prior Start With Case Decode Rownum Union UnionALL Intersect Create View Simple View Complex View View Data Dictonary Drop View Create Sequence Use Sequence Alter and Drop Sequence Create Index Drop Index Enable Enable & Disable Index Synonym Comment On Table Rank Function Dense_Rank Function Default value NULL And NVL COUNT FUNCTION SOUNDEX FUNCTION