View Full Version : oracle insights


  1. Data Fetch in XML Structure using DBMS_XMLGEN
  2. DDL_LOCK_TIMEOUT in Oracle 11g
  3. Calling Concurrent Program from UNIX
  4. Function To Calculate Business Days
  5. Procedure to accept a list of values in a single parameter
  6. Convertion of Time Zones in Oracle
  7. Script to create readonly schema of existing schema.
  8. Script to Rebuild the indexes that really needs to be rebuild .
  9. Cross Platform Migration An Unproblematic Approach (Windows-UNIX ) Oracle 10\11g
  10. Using PRAGMA - I
  11. Sending mail using UTL_SMTP.
  12. A Roadmap To Query Tuning
  13. Fast-Start Failover An Overview In Dataguard Environment
  14. Bulk-Fetching from a Cursor
  15. Table Partition Performance analysis
  16. Impact Of Nologging Operations In High Availability Environments
  17. LogMiner Utility, useful stuff ?
  18. 10g REGULAR EXPRESSIONS (REGEXP_REPLACE)
  19. 10g REGULAR EXPRESSIONS (REGEXP_SUBSTR)
  20. 10g REGULAR EXPRESSIONS (REGEXP_INSTR)
  21. 10g REGULAR EXPRESSIONS (REGEXP_LIKE)
  22. Oracle 10g Feature: REGULAR EXPRESSIONS - 3
  23. Oracle 10g Feature: REGULAR EXPRESSIONS - 2
  24. Oracle 10g Feature: REGULAR EXPRESSIONS - 1
  25. Using Subqueries - 1
  26. PL/SQL-CURSOR - 4
  27. Pivoting - 3
  28. Pivoting - 2
  29. Pivoting - 1
  30. Using Subqueries - 2
  31. Pivoting - 1
  32. GENERAL FUNCTIONS
  33. CONVERSION FUNCTIONS
  34. CHARACTER FUNCTIONS
  35. DATE FUNCTIONS
  36. PL-SQL Tips (SINGLE ROW FUNCTIONS)
  37. Important Date Related Queries - 2
  38. Important Date Related Queries - 1
  39. Oracle 11g New Features.-II
  40. Oracle 11g New Features-I
  41. The function return amount of data at a time (Oracle)
  42. Reporting Function
  43. Windowing Function - 2
  44. Windowing Function - 1
  45. CUME_DIST Function.
  46. WIDTH_BUCKET Function
  47. NTILE Function
  48. Ranking Function
  49. Using PRAGMA - II
  50. TRIGGERS - 3
  51. TRIGGERS - 2
  52. TRIGGERS - 1
  53. Pl/sql-package - 4
  54. PL/SQL-PACKAGE - 3
  55. PL/SQL-PACKAGE - 2
  56. PL/SQL-PACKAGE - 1
  57. SQL Tuning tricks
  58. EXCEPTIONS - 4
  59. EXCEPTIONS - 2
  60. EXCEPTIONS - 3
  61. EXCEPTIONS - 1
  62. PL/SQL-FUNCTIONS - 2
  63. PL/SQL-FUNCTIONS - 1
  64. PL/SQL-PROCEDURES - 3
  65. PL/SQL-PROCEDURES - 2
  66. PL/SQL-PROCEDURES - 1
  67. Oracle REF CURSOR - 3
  68. Oracle REF CURSOR - 2
  69. Oracle REF CURSOR - 1
  70. PL/SQL-CURSOR - 5
  71. PL/SQL-CURSOR - 3
  72. PL/SQL-CURSOR - 2
  73. PL/SQL-CURSOR - 1
  74. Using Partition -2
  75. Using Partition -1
  76. USING EXTERNAL TABLE
  77. Oracle PL/SQL 9i/10g - Sample Programs
  78. Oracle PL/SQL 9i/10g - Introduction
  79. Using Merge command
  80. Oracle Database Links (DB Link)
  81. Oracle Tips and Tricks--SQL-I