Oracle Tutorial – Learn how to create and drop objects on Oracle database.
Learn how to use DML Statements, DDL Statements, Conditional Statements, SQL queries, joins, data types.
The main objects in Oracle database are tables, procedures, functions, triggers, cursors, views, packages, constraints, collections, records, indexes, exceptions.
Oracle Create Table – show how to create a table in Oracle database.
Oracle Insert – insert statement is used to add new records in a table.
Oracle Update – update statement is used to modify column records in a table.
Oracle Delete – delete statement is used to delete rows in a table.
Oracle Anonymous Block – explain how to use Anonymous Block.
Oracle Data Types – show a list of the main data types like: number, varchar2, date, clob.
Oracle Conditional Statements
Oracle Transaction Statements – explain the Transaction Statements like: commit, savepoint, rollback.
Oracle Loop Statements – syntax and examples of Loop Statements: loop, while loop, for loop, cursor for loop.
Oracle Cursors – learn how to declare a cursor, open and close a cursor.
Oracle Create Procedure – contains the syntax and example how to create a procedure.
Oracle Create Function – contains the syntax and example how to create and use a function.
Oracle Create Package – show the syntax for package specification and package body.
Oracle Create View – show how to create a view in Oracle database.
Oracle Create Trigger – simple example how to create a trigger.
Oracle Exception – examples of predefined and user-defined exceptions.
Oracle Functions – predefined functions like to_number, to_date, to_char, substr.
Oracle DML Statements – statements like insert, update, delete.
Oracle Joins – table joins: Inner Join, Left Outer Join, Right Outer Join.
Oracle Select Query – learn how to filter data with WHERE clause and GROUP BY clause.
Oracle System Packages – system packages like: UTL_FILE, UTL_SMTP.
Oracle Table – syntax to add new columns, modify and drop columns, rename table, add constraints.
Oracle Forms and Reports – steps to use Oracle Forms and Reports.