PDA

View Full Version : BEGINNERS GUIDE TO SQL PLUS



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

tanergulleri
2011-07-16, 08:31 PM
good post thanks

newbie_engineer
2011-08-02, 03:23 AM
Nice share, bro....keep it up....