Irna
2011-05-07, 01:32 AM
ABSTRACT
A beginner's guide to SQL Plus. The tables are built and they have been populated with data. How can you now use SQL
Plus to retrieve and manipulate this data? This session will provide the information necessary for the retrieving and
manipulation of existing table data using only SQL Plus. The session will cover commonly used system tables, query syntax,
ordering and grouping select results, operators, and conditions as well as SQL Plus editing commands and functions. The
attendee will immediately be able to use SQL Plus in their job function. No SQL Plus experience is necessary, but an
understanding of Oracle table structure would be helpful.
CONTENT
• 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
A beginner's guide to SQL Plus. The tables are built and they have been populated with data. How can you now use SQL
Plus to retrieve and manipulate this data? This session will provide the information necessary for the retrieving and
manipulation of existing table data using only SQL Plus. The session will cover commonly used system tables, query syntax,
ordering and grouping select results, operators, and conditions as well as SQL Plus editing commands and functions. The
attendee will immediately be able to use SQL Plus in their job function. No SQL Plus experience is necessary, but an
understanding of Oracle table structure would be helpful.
CONTENT
• 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