This tutorial will explain about Oracle SQL and PL/SQL concepts and examples in Oracle.

SQL:

  1. Oracle Data types
  2. Oracle Date functions
  3. Oracle Numeric Functions
  4. Oracle Other functions
  5. Oracle Conversion functions
  6. SQL – Aggregate functions in Oracle
  7. Type of SQL statements
  8. Oracle Data Manipulation Language
  9. Oracle Data Definition Language
  10. Oracle Data Control Language
  11. Oracle Transaction Control Languages(TCL)
  12. Oracle Check Constraints
  13. Oracle Primary Key
  14. Oracle Foreign Key
  15. Oracle Unique Key
  16. Oracle View
  17. Joins in Oracle
  18. Oracle Synonym
  19. Oracle Sequence
  20. Oracle Performance Tuning
  21. Oracle Query Processing
  22. Oracle AutoTrace
  23. Oracle Explain Plan
  24. Oracle Optimizer Hints
  25. Oracle SQLTrace
  26. Oracle TkProf Utility
  27. Oracle Index
  28. nth Highest Salary

PL/SQL:

  1. Introduction to PL/SQL
  2. Stored Procedure
  3. Stored Function
  4. Oracle Packages
  5. Oracle Triggers
  6. Pragma Autonomous Transactions
  7. Oracle Dynamic SQL
  8. Exception in Oracle
  9. Cursors in Oracle
  10. Oracle Collection

© 2016 – 2023, https:. All rights reserved. On republishing this post, you must provide link to original post

Popular Articles you may like :