View Full Version : insights

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