Oracle PLSQL Development 

offered by Besant Technologies, Velachery - Chennai

List the features of Oracle Database 11g

Discuss the basic design, theoretical, and physical aspects of a relational database

List the capabilities of SQL SELECT statements

Generate a report of data from the output of a basic SELECT statement

Write queries that contain a WHERE clause to limit the output retrieved

List the comparison operators and logical operators that are used in a WHERE clause

Describe the differences between single row and multiple row functions

Manipulate strings with character function in the SELECT and WHERE clauses

Describe implicit and explicit data type conversion

Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Use the aggregation functions in SELECT statements to produce meaningful reports

Divide the data into groups by using the GROUP BY clause