WA1276 Introduction to Oracle 9i: SQL 1. SQL Data Definition Language create table statement select not null default alter, drop describe, rename 2. Using The Sql*Plus Tool interactive sql with sql*plus graphical sql*plus exit or quit host or $ spool start or @ list, save, get run or / edit, append, change, del, input 3. SQL Data Manipulation Language about sql dml select, insert insert using select delete, update about transactions rollback, commit, savepoint complex table references 4. Introduction To SQL Queries select distinct alias names 5. Building A Where Clause equality, inequality boolean null and between is [not] null [not] between [not] like in 6. Ordering The Result Table about the order by clause including multiple columns specifying the sort sequence null values and order by sorting by un-selected columns referring to column aliases 7. Pseudo Columns And Functions Working with Joins the pseudo columns rownum, sysdate, user & uid the dual table 8. Joining Tables equi-join reflexive join non key-join outer join 9. Using Set Operators Upon Tables set operator examples union, intersect, minus performing a full outer join 10. About Summary Functions 11. Using Subqueries 12. Creating & Selecting Groups group by example selecting data from the base tables having 13. Creating & Using Views 14. Indexes & Synonyms 15. Understanding The Data Dictionary about the data dictionary query dd: user_tables, user_tab_columns, user_objects 16. Build Simple Sql*Plus Reports about the data dictionary query dd: user_tables, user_tab_columns, user_objects