Like, upper, lower, initcap, inner join

Outer join, substr, floor, ceil, round, dual

Foreign Key, user_tables, Theory on Stored Procedures

Create, replace, drop stored procedures, comment, variables, assignment,for loop,server output in parameter,execute SP

If conditions, insert statement in SP, call another SP

Stored Functions, return values, package header and body

Select into statement in SP, exception handler in SP