Complete tutorial on Oracle SQL and PL-SQL covering all definitions and syntax with examples
Complete tutorial on Oracle SQL and PL-SQL covering all definitions and syntax with examples.Below is list of SQL and PL-SQL topics covered in the app:SQL:-1. Create Table2. Alter Table3. Rename and Drop Table4. Insert into Table5. Update and Delete Statements6. Transaction Control Statements7. SELECT Statement8. Components of SQL Statement9. Truncate Table10. BETWEEN Operator11. DISTINCT/UNIQUE12. Character Manipulation: CONCAT13. WHERE Clause14. INSTR Function15. DUAL (Dummy table)16. SQL Func
tions17. Conversion Functions18. DECODE Function19. Implicit & Explicit Conversion20. Using CASE in SQL21. NVL, NVL2 & COALESCE22. Date Functions23. GROUP BY Clause24. GROUP BY Clause with Filter25. HAVING Clause26. Group Functions27. SQL Joins28. Inner Vs Outer Join29. COMMIT-ROLLBACK Data State30. Locking in SQL31. MERGE Statement32. Types of Tables33. RR & DD Date Format34. Pseudo-coloumns35. SQL Constraints36. Views & Inline Views37. WITH CHECK OPTION in Views38. Indexes39. Create User and Grants40. SynonymsPL-SQL:-1. PL SQL Block2. Types of Variables3. SQL Functions in PL-SQL4. Conditional/Selection Control5. Loops in PL-SQL6. Cursors in PLSQL7. Cursors with Parameters8. PL-SQL Reference Cursors9. Bulk Collect and Bulk Bind10. PL/SQL Records Data Type11. Composite Data Type - VARRAY12. Composite Data Type - NESTED TABLES13. Composite Data Type - INDEX BY TABLE14. Implicit Exceptions15. Explicit Exceptions16. Exception Trapping Functions17. PL/SQL PROCEDURE18. PL/SQL FUNCTION19. PL/SQL PACKAGE20. Trigger
... moreless ...