Let's Develop in Oracle


Auditing User Login-Logoff activities using System Level Trigger

New Features for Developers in Oracle 11g

Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

New Articles

  • Script to Export Packages, Procedures, Functions to individual files from Oracle at Client Side
  • Foreign Key in Oracle Data Warehouse - Best Practice
  • Why Primary Key Foreign Key Relationship and Join Elimination
  • Complex View Merging Transformation and ORA-00979 in Oracle 12c
  • Oracle SQL Developer - Autotrace - Insufficient Privileges
  • Truncate Command and Table Statistics
  • Convert XML to Rows and Columns in Oracle
  • Generate XML data using SQL in Oracle Database
  • SQL Tuning: Partition Pruning and HASH JOIN - Real Life Example
  • Tune Complete Refresh of Materialized View by atomic_refresh=>false parameter of dbms_mview.refresh

Popular Posts

  • Oracle: Total Size of The Database
  • Oracle: DBMS_STATS Gather Statistics of Schema, Tables, Indexes
  • ORA-01157: cannot identify/lock data file string - see DBWR trace file
  • Load XML File in Oracle Table
  • Export Packages, Procedures, Functions to individual files from Oracle at Client Side
  • Oracle: Difference between wm_concat and ListAgg
  • Load CSV file in Oracle using PL/SQL
  • Oracle: Extract Initials of Names
  • Oracle: Function ISNUMERIC Check Value is Number or Not
  • Create XML file using PL/SQL

Oracle Error Codes

ORA-00000   •   ORA-00001   •   ORA-00018
ORA-00020   •   ORA-00027   •   ORA-00054
ORA-00257   •   ORA-00600   •   ORA-00604
ORA-00843   •   ORA-00849   •   ORA-00904
ORA-00911   •   ORA-00936   •   ORA-00942
ORA-01031   •   ORA-01034   •   ORA-01017
ORA-01157   •   ORA-01403   •   ORA-01422
ORA-01436   •   ORA-01439   •   ORA-01460
ORA-01489   •   ORA-01555   •   ORA-01722
ORA-01723   •   ORA-01779   •   ORA-01830
ORA-02041   •   ORA-02303   •   ORA-02438
ORA-03113   •   ORA-03135   •   ORA-04031
ORA-06502   •   ORA-06512   •   ORA-06530
ORA-06550   •   ORA-08002   •   ORA-12154
ORA-12514   •   ORA-12545   •   ORA-12560
ORA-16000   •   ORA-23404   •   ORA-27101
ORA-28002   •   PLS-00172

Labels

Oracle SQL (68) Oracle Tips (63) Ora-Codes (51) Optimization (37) Oracle DBA (26) Oracle PL/SQL (25) Analytical Functions (13) Date/Time (11) Connect By (10) Oracle Puzzle (8) String Aggregation (8) Java Script (6) Regular Expression (6) Oracle 12c (5) Subquery Factoring (5)

My Profiles

     

Total Pageviews

Followers

Blog Archive

  • ►  2017 (9)
    • ►  September (1)
    • ►  August (1)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2016 (17)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (2)
    • ►  January (3)
  • ►  2015 (20)
    • ►  December (2)
    • ►  November (2)
    • ►  October (2)
    • ►  September (3)
    • ►  August (2)
    • ►  July (3)
    • ►  June (2)
    • ►  May (1)
    • ►  April (2)
    • ►  January (1)
  • ►  2014 (28)
    • ►  December (1)
    • ►  November (1)
    • ►  October (4)
    • ►  September (2)
    • ►  August (1)
    • ►  July (3)
    • ►  June (2)
    • ►  May (3)
    • ►  April (4)
    • ►  March (2)
    • ►  February (3)
    • ►  January (2)
  • ▼  2013 (33)
    • ►  December (3)
    • ►  November (2)
    • ►  August (2)
    • ►  July (2)
    • ►  June (3)
    • ►  May (6)
    • ►  April (4)
    • ►  March (5)
    • ►  February (4)
    • ▼  January (2)
      • Auditing User Login-Logoff activities using System...
      • New Features for Developers in Oracle 11g
  • ►  2012 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (4)
    • ►  September (5)
    • ►  August (1)
    • ►  July (1)
    • ►  June (3)
    • ►  May (4)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (23)
    • ►  November (5)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (3)
    • ►  February (4)
    • ►  January (3)
  • ►  2010 (65)
    • ►  December (4)
    • ►  November (3)
    • ►  October (1)
    • ►  September (4)
    • ►  August (3)
    • ►  July (3)
    • ►  June (10)
    • ►  May (5)
    • ►  April (5)
    • ►  March (7)
    • ►  February (15)
    • ►  January (5)
  • ►  2009 (39)
    • ►  December (9)
    • ►  November (8)
    • ►  October (22)
Copyright © 2009-2016 | Nimish Garg | All rights reserved.. Powered by Blogger.