Introduction
Oracle Data Types
Sub Languages with Examples
-
What is DDL (11:28)
-
create in ddl (11:10)
-
alter in ddl (15:18)
-
truncate in ddl (8:23)
-
rename in ddl (3:19)
-
drop, flashback, purge in ddl (36:57)
-
What is DML (7:40)
-
insert in DML (32:02)
-
update in DML (17:21)
-
delete in DML (6:01)
-
insert all in DML (18:39)
-
merge in DML (19:55)
-
DRL / DQL (34:04)
-
Arithmetic operators in c (5:47)
-
Relational Operators in SQL (5:38)
-
Logical Operators in SQL (7:58)
-
Special Operators in SQL (34:59)
-
Set Operators in SQL (14:59)
-
Concatenation Operator in SQL (2:41)
-
Transaction Control Language (TCL) (30:45)
-
Data Control Language (DCL) (28:25)
Group By, Having, Fetch, Offset Clauses
Join operations in SQL
SubQueries in SQL
Constraints in SQL
Set Operators in SQL
PL/SQL
-
Introduction to PL/SQL (16:28)
-
PL/SQL Procedures (24:52)
-
Variables in PL/SQL (20:11)
-
String Datatypes in PL/SQL (17:47)
-
String functions in PL/SQL (31:01)
-
Number Datatypes in PL/SQL (8:12)
-
Number related Functions (43:13)
-
Date Datatypes in PL/SQL (11:14)
-
Date Functions in PL/SQL (20:17)
-
How to read input from user in PL/SQL (10:21)
-
%TYPE and %ROWTYPE in PL/SQL (21:18)
-
Control Statements in PL/SQL (9:38)
-
If Statement in PL/SQL (36:57)
-
Case in PL/SQL (20:26)
-
For loop in PL/SQL (30:40)
-
While and Simple Loops (18:45)
-
Introduction to Cursors (15:03)
-
Implementing Cursors in PL/SQL (44:23)
-
Ref Cursors in PL/SQL (8:49)
-
Error Handling in PL/SQL (48:40)
