Learn How to connect With the database using SQL*Plus Using Users Such as SYS, HR etc. With very Easy Examples
Learn How to copy table with or without data using Create Table AS command By Manish Sharma.
Blocks are basic programming unit in PL/SQL Read and learn more about Block Types By Manish Sharma.
Learn proper way of Declaring and Initializing Variables in PL/SQL By Manish Sharma.
Learn how to fetch values from a table into the variable Using SELECT...INTO statement in PL/SQL By Manish Sharma.
Anchored Datatype a.k.a %Type in PL/SQL read and learn what are anchored datatype and how to declare them with simple examples in PL/SQL By Manish Sharma.
Learn What are Constants how to declare and initialize them in PL/SQL By Manish Sharma.
Learn concepts of Bind Variable, Variable Commands, Print and Auto Print command and conqure the Exam as well as Interview
Introduction of Conditional Control Statements In PL/SQL.
Learn the concept of simple IF-THEN Statements in PL/SQL with Examples
Learn the concept of IF-THEN-ELSE Statements in PL/SQL with Examples
IF-THEN-ELSIF Statements in PL/SQL with Examples