Oracle Sql (Structured Query Language) Overview in Java Course for JDBC purpose
- Dbms and Rdbms Concept
- Data Definition Language (DDL) (Create, Alter, Drop, Rename ,Truncate)
- Table, View, Synonyms
- Key Constraint: (Primary, Foreign, Unique)
- Data Manipulation Language (DML) (Insert, Update, Delete)
- Transaction Control Statement(TCS) (Commit, Rollback, Savepoint, Set Transaction)
- Query Language (QL) (Select, From, Where, Group By, Having, Order by)
- Data Retrival from Single and Multiple Table
- Cartesian product/Cross Product
- Sub-Query, Scalar SubQuery in Select,
- Logical (All, And, Any, Between, Exits, In, Not In, Like, Or, Some,)
- Comparison/Relational ((), =, !=, <>, >, >=, <, <=)
- Aggregate Functions
- Sum(), Avg(), Min(), Max(), Count()
- Merge Statement
Oracle PL/Sql (Procedural Language) Overview in Java Course for JDBC purpose
- Introduction TO PLSQL
- PLSQL block Structure/Architecture
- Data Types
- Declaring Variables
- Control Structures
- Conditional Control Statements
If ...Then
If ...Then ...Else
If ...Then ...ElsIf
- Iterative Statements
For(...Range...)Loop .. End Loop
While(...condition...)Loop ... End Loop
Loop ... End Loop --Explicite Exit Statement
- Exit Statement
- GoTo Statement
- Null Statement
- Into Statement
- Explicit Cursor
- Implicit Cursors (Dml/Select Into)
Attributes(SQL%Found, SQL%NotFound, SQL%RowCounts, SQL%IsOpen)
- Exceptions Handling
- Sub-Programs (Procedures and Functions)
- Stored Programs (Procedures and Functions)
|
|
