Database – Pl/Sql

General Articles

  1. TEN Oracle PL/SQL Performance Tips
  2. Virtualbox: Oracle Database: could not open connection to the host on port 1521 connect failed
  3. Convert columns into rows by using Sql
  4. Check whether object is locked?
  5. Increase tablespace?
  6. NEVER GO “ LONG “ !!!
  7. Oracle Pipelined Table Function
  8. Debugging the flow of pl/sql procedure using DBMS_UTILITY.FORMAT_CALL_STACK
  9. Reading CLOB using Regular Expression
  10. Invisible Indexes
  11. SecureFiles – Oracle 11g New Feature
  12. Best Practices for Statistics Gathering on Oracle 11g
  13. SQL Plan Management
  14. Partitioning on Virtual Columns
  15. Query Result Cache
  16. Pivot & Unpivot
  17. Oracle Data Redaction
  18. Multiple Indexes on Same Set of Columns
  19. Invisible Columns in Oracle 12c
  20. Index Rebuilding
  21. Read Only Tables
  22. Components of an Oracle Virtual Private Database Policy
  23. Virtual Private Database
  24. Handling ORA-19909 & ORA-01110 ( Managed Recovery Process )
  25. Identity Columns in Oracle 12c
  26. FETCH FIRST ROWS & OFFSET clause
  27. ASSM : AUD$ and FGA_LOG$
  28. Multiplex Redo Log
  29. Multiplex Control files on ASM
  30. Conditional Compilation in Oracle

 Issues Encountered

  1. ORA-02085: database link not working
  2. Performance Issues while creating a table using SELECT
  3. Unexpected exception in procedure -1476: ORA-01476: divisor is equal to zero