Oracle - Joins and Stored Procedures

video(s)

‍Part 01 - Like, upper, lower, initcap, inner join

Part 02 - Outer join, substr, floor, ceil, round, dual

Part 03 - Foreign Key, user_tables, Theory on Stored Procedures

Part 04 - Create, replace, drop stored procedures, comment, variables, assignment, for loop, serveroutput, in parameter, execute SP

Part 05 - If conditions, insert statement in SP, call another SP

Part 06 - Stored Functions, return values, package header and body

Part 07 - Select into statement in SP, exception handler in SP

Nagarajan P

Ensure to get the basics right.