Let's Develop in Oracle


ORA-23404 refresh group does not exist

ORA-00018 maximum number of sessions exceeded

Two Dimension Array in PL/SQL

ORA-00001 unique constraint violated

ORA-00000 normal, successful completion

Create CSV file using PL/SQL

Extracting text between html tags (removing html tags)

ORA-01779: cannot modify a column which maps to a non key-preserved table

ORA-16000: database open for read-only access

Examples of Rollup and Grouping Sets

Oracle DBA Daily Checklist

Set SQLPROMPT - Customizing SQL Prompt

Alpha Numeric Counter Or Sequence

Column to Rows - Number Separated By Any Character

SYS_CONTEXT

Playing With Truncate and Date

Top N query - 3rd highest salary

Using Statspack Report

ORA-01436: CONNECT BY loop in user data

Oracle: Getting Simulated Cumulative Sum (Running Total)

Oracle: Delete duplicate rows from table

Oracle: Extract Initials of Names

ORA-01723: zero-length columns are not allowed

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

New Articles

  • Top 18 features of Oracle 18c
  • Oracle Cloud Performance Benchmark by Accenture
  • ORA-30009: Not enough memory for CONNECT BY operation
  • Oracle 12c Top 10 New Partitioning Features
  • Oracle 18c Database - Autonomous Database Cloud
  • 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

Popular Posts

  • Top 18 features of Oracle 18c
  • 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 CSV file in Oracle using PL/SQL
  • ORA-01830 date format picture ends before converting entire input string
  • One Time Immediate Job in Oracle
  • ORA-01489: result of string concatenation is too long
  • Oracle: Function ISNUMERIC Check Value is Number or Not
  • ORA-00020 maximum number of processes exceeded

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   •   ORA-30009   •   PLS-00172

Labels

Oracle SQL (68) Oracle Tips (63) Ora-Codes (52) 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) Oracle 12c (6) Regular Expression (6) Subquery Factoring (5)

My Profiles

     

Total Pageviews

Followers

Blog Archive

  • ►  2018 (2)
    • ►  March (1)
    • ►  February (1)
  • ►  2017 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  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)
  • ►  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)
      • ORA-23404 refresh group does not exist
      • ORA-00018 maximum number of sessions exceeded
      • Two Dimension Array in PL/SQL
      • ORA-00001 unique constraint violated
      • ORA-00000 normal, successful completion
    • ►  September (2)
      • Create CSV file using PL/SQL
      • Extracting text between html tags (removing html t...
    • ►  August (1)
      • ORA-01779: cannot modify a column which maps to a ...
    • ►  July (1)
      • ORA-16000: database open for read-only access
    • ►  June (1)
      • Examples of Rollup and Grouping Sets
    • ►  May (1)
      • Oracle DBA Daily Checklist
    • ►  April (2)
      • Set SQLPROMPT - Customizing SQL Prompt
      • Alpha Numeric Counter Or Sequence
    • ►  March (3)
      • Column to Rows - Number Separated By Any Characte...
      • SYS_CONTEXT
      • Playing With Truncate and Date
    • ►  February (4)
      • Top N query - 3rd highest salary
      • Using Statspack Report
      • ORA-01436: CONNECT BY loop in user data
      • Oracle: Getting Simulated Cumulative Sum (Running ...
    • ►  January (3)
      • Oracle: Delete duplicate rows from table
      • Oracle: Extract Initials of Names
      • ORA-01723: zero-length columns are not allowed
  • ►  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.