The Complete Oracle PL/SQL Course > Basic PL/SQL Block

Introduction to PL/SQL Anonymous Block

15.2k

Learner's Ratings

4.7

Overall Rating

  • 84%
  • 5%
  • 11%
  • 0%
  • 0%

Reviews

Y
Yogesh Jadhav
4

THANK FOR HIGH PROFILE COURSES .TANK YOU ITS FREE FOR LIKE ME THIS IS SO IMPORTANT FOR MY LIFE BETER APORTUNITY.

S
Suvajit Ghosh
5

-- Check if V_SERIES_VALUE exceeds 300 before printing IF V_SERIES_VALUE > 300 THEN EXIT;

Y
yug Babariya
5

I like graphic design

K
KB
5

Request: Kindly, allow the download of PL/SQL resources.

M
Moazzam Ali
5

Excellent

A
Aditya Jadhav
5

very nice and informative and its very useful for beeginer student.

harsh88490@gmail.com
5

This is Nice Course and sir is great because sir gives so manny information to PL/SQL. Thank You For This.

Y
yash
5

Best PL/SQL course available.

S
sanjay
5

it is very hepful for me best cource best example best teacher thanks the website owner

P
Prabhat Yadav
5

Superb and amazing 😍🤩 enjoyable experience.

Show More
Recommended Courses
Course Content

  1. Introduction to PL/SQL
    12m 1s

  1. Basic Understanding of Procedural Language / Structured Query Language (PL/SQL)
    14m 56s
  2. Introduction to PL/SQL Anonymous Block
    11m 11s
  3. Variable Declaration in PL/SQL
    33m 29s
  4. Practical: Variable Declaration in PL/SQL
    9m 51s
  5. Variable Assignment in PL/SQL
    17m 41s
  6. Practical: Variable Assignment in PL/SQL
    12m 17s
  7. Working with Variables in PL/SQL
    21m 26s
  8. Practical: Working with Variables in PL/SQL
    13m 49s
  9. Comment Styles in PL/SQL
    12m 52s
  10. Assignment: Basics of PL/SQL
    2m 40s

  1. IF-THEN-ELSE Statements in PL/SQL
    18m 14s
  2. Practical: IF-THEN-ELSE Statements in PL/SQL
    17m 28s
  3. CASE Statement in PL/SQL
    16m 27s
  4. Practical: CASE Statement in PL/SQL
    21m 42s
  5. GOTO Statement in PL/SQL
    11m 13s
  6. Practical: GOTO Statement in PL/SQL
    25m 7s
  7. Assignment: Conditional Selection Statements
    2m 56s

  1. Basic Loop Statement in PL/SQL
    27m 23s
  2. Practical: Basic Loop Statement in PL/SQL
    8m 47s
  3. Numeric FOR Loop in PL/SQL
    10m 58s
  4. Practical: Numeric FOR Loop in PL/SQL
    18m 57s
  5. WHILE Loop in PL/SQL
    10m 19s
  6. Practical: WHILE Loop in PL/SQL
    14m 52s
  7. CONTINUE Statement in PL/SQL
    12m 36s
  8. Practical: CONTINUE Statement in PL/SQL
    27m 55s
  9. Assignment: Iteration
    3m 55s

  1. Exception Handling in PL/SQL
    20m 51s
  2. Practical: Exception Handling in PL/SQL
    18m 44s
  3. RAISE Statement for Exception Handling in PL/SQL
    30m 24s
  4. Practical: RAISE Statement for Exception Handling in PL/SQL
    20m 37s
  5. RAISE_APPLICATION_ERROR in PL/SQL
    10m 51s
  6. Practical: RAISE_APPLICATION_ERROR in PL/SQL
    24m 58s
  7. OTHERS Exception Handling in PL/SQL
    13m 29s
  8. Practical: OTHERS Exception Handling in PL/SQL
    37m 51s
  9. Assignment: PL/SQL Exception Handling
    5m 13s

  1. Introduction to Record Type
    6m 35s
  2. Table Based Records in PL/SQL
    23m 42s
  3. Practical: Table Based Records in PL/SQL
    23m 5s
  4. User Defined Records in PL/SQL
    28m 52s
  5. Practical: User Defined Records in PL/SQL
    17m 59s
  6. Assignment: Record Types
    3m 39s

  1. Cursors in PL/SQL
    29m 7s
  2. Practical: Cursors in PL/SQL
    29m 41s
  3. Parameterized Cursors in PL/SQL
    10m 42s
  4. Practical: Parameterized Cursors in PL/SQL
    27m 34s
  5. Cursor FOR Loop in PL/SQL
    11m 28s
  6. Practical: Cursor FOR Loop in PL/SQL
    30m 28s
  7. Assignment: Cursor
    4m

  1. Procedures in PL/SQL
    01h 5m 25s
  2. Practical: Procedures in PL/SQL Part-1
    39m 41s
  3. Practical: Procedures in PL/SQL Part-2
    01h 3m 11s
  4. Assignment: Procedures
    5m 49s

  1. Functions in PL/SQL
    31m 29s
  2. Practical: Functions in PL/SQL Part-1
    34m 38s
  3. Practical: Functions in PL/SQL Part-2
    49m 1s
  4. Assignment: Functions
    4m 12s

  1. Packages in PL/SQL
    01h 51s
  2. Practical: Packages in PL/SQL Part-1
    01h 5m 59s
  3. Practical: Packages in PL/SQL Part-2
    58m 9s
  4. Assignment: Package
    7m 12s

  1. Triggers in PL/SQL
    16m 46s
  2. Row-Level Triggers in PL/SQL
    33m 12s
  3. Practical: Row-Level Triggers in PL/SQL
    50m 35s
  4. Statement-Level Triggers in PL/SQL
    17m 51s
  5. Practical: Statement-Level Triggers in PL/SQL
    19m 47s
  6. Compound Triggers in PL/SQL
    26m 43s
  7. Practical: Compound Triggers in PL/SQL
    31m 47s
  8. Assignment: Trigger
    3m 44s

  1. Associative Arrays in PL/SQL
    34m 51s
  2. Practical: Associative Arrays in PL/SQL
    28m 2s
  3. Nested Tables in PL/SQL
    36m 23s
  4. Practical: Nested Tables in PL/SQL
    20m 19s
  5. VARRAY in PL/SQL
    30m 40s
  6. Practical: VARRAY in PL/SQL
    21m 54s
  7. Collection Methods in PL/SQL
    47m 34s
  8. Practical: Collection Methods in PL/SQL
    16m 47s
  9. BULK COLLECT and FORALL in PL/SQL
    41m 43s
  10. Practical: BULK COLLECT and FORALL in PL/SQL
    45m 45s
  11. Assignment: PL/SQL Collection
    6m 15s

  1. EXECUTE IMMEDIATE Statement in PL/SQL
    26m 40s
  2. Practical: EXECUTE IMMEDIATE Statement in PL/SQL
    37m 11s
  3. Assignment: Miscellaneous
    4m 55s

  1. Course Summary
    16m

  1. Interview Questions
    25m 16s

  1. Career Guideline
    2m 14s
Enroll For Free