Syllabus of Oracle and plsql
Oracle
Introduction to Oracleand its architecture
Definition of data,database
Definition of SQL, types of sql like dml,ddl,,dcl, tcl etc.
Define query
Create statements
Insert statements
Update statements
Alter statements
Truncate statements
Drop statements
Delete statements
Creating date function, number function, text function and mathematical function
Definition of sequence, types,queries on sequence
Definition of joins,types ,queries on each join
Definition of subquery,types,examples on different types of subquery
Definition of synonym,examples on synonym
Plsql
Definition of plsql
Differeces between SQL and plsql
Basic programs on plsql
Definition of procedures, examples on procedures
Definition of function, types, examples on function
Definition on cursors,types,examples on cursors
Definition on triggers, types, examples on triggers