Palupi
2011-05-20, 10:50 PM
TOPICS TO BE DISCUSSED
• Why is it important to learn SQL Plus?
• Editing Commands
• Common Objects
• Common and Useful SQL Tables
• Queries
• Simple Query
• Where Clause
• Order By
• Having & Group By
• Query Joins and Outer Joins
• Saving & Re-executing SQL Scripts
• Useful SQL Plus Environment Variables
• Arithmetic Expressions
• Converting Values
• To_Date, To_Char, To_Number
• Last_Day, Add_Months, Months_Between, Next_Day
• Decode
• Functions
• Numbers, Characters and Groups
• Using SQL to Write SQL
• Error Messages
• Why is it important to learn SQL Plus?
• Editing Commands
• Common Objects
• Common and Useful SQL Tables
• Queries
• Simple Query
• Where Clause
• Order By
• Having & Group By
• Query Joins and Outer Joins
• Saving & Re-executing SQL Scripts
• Useful SQL Plus Environment Variables
• Arithmetic Expressions
• Converting Values
• To_Date, To_Char, To_Number
• Last_Day, Add_Months, Months_Between, Next_Day
• Decode
• Functions
• Numbers, Characters and Groups
• Using SQL to Write SQL
• Error Messages