Let's Develop in Oracle


Avoiding unnecessary function calls to optimize SQL statements

Prefer Oracle Native Date Arithmetic over ANSI INTERVAL

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

New Articles

  • Analytical SQL - Running Total - Order by without Partition By
  • Analytical SQL - SUM with Partition By
  • Analytical SQL - SUM without Window Clause
  • Oracle Database 21c on-premises is here - New Features
  • Oracle: String to Date, Timestamp with Timezone
  • Star Pattern by SQL in Oracle Database
  • LISTAGG DISTINCT - Remove Duplicates - Oracle 19c
  • Redo Files, Redo Group and Redo Thread in Oracle Database
  • Generate Nested JSON using SQL in Oracle Database
  • Parse JSON data in Oracle Database using JSON_TABLE in SQL
  • Automatic Indexing in Oracle 19c Autonomous Database

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-01476   •   ORA-01489   •   ORA-01555
ORA-01722   •   ORA-01723   •   ORA-01779
ORA-01821   •   ORA-01830   •   ORA-01843
ORA-02030   •   ORA-02041   •   ORA-02303
ORA-02438   •   ORA-03113   •   ORA-03135
ORA-04031   •   ORA-06502   •   ORA-06512
ORA-06530   •   ORA-06550   •   ORA-08002
ORA-12838   •   ORA-12154   •   ORA-12514
ORA-12545   •   ORA-12560   •   ORA-16000
ORA-23404   •   ORA-27101   •   ORA-28002
ORA-30009   •   PLS-00172

Popular Posts

  • ORA-01157: cannot identify/lock data file string - see DBWR trace file
  • Efficient way to UPDATE bulk of records in Oracle Database
  • Load CSV file in Oracle using PL/SQL
  • ORA-03135: connection lost contact
  • Oracle Database 12c New Features for Developers
  • One Time Immediate Job in Oracle
  • ORA-01830 date format picture ends before converting entire input string
  • Parse JSON data in Oracle Database using JSON_TABLE in SQL
  • ORA-06502: invalid LOB locator specified
  • Why prefer COALESCE over NVL

Labels

Oracle SQL (88) Oracle Tips (70) Ora-Codes (57) Optimization (42) Oracle DBA (28) Oracle PL/SQL (26) Analytical Functions (17) Date/Time (13) Oracle Puzzle (12) Connect By (10) String Aggregation (10) Oracle 12c (8) Regular Expression (7) Java Script (6) Subquery Factoring (5)

My Profiles

     

Total Pageviews

Followers

Blog Archive

  • ►  2022 (3)
    • ►  March (1)
    • ►  February (2)
  • ►  2021 (5)
    • ►  September (1)
    • ►  June (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2020 (8)
    • ►  December (2)
    • ►  August (1)
    • ►  June (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2019 (15)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (2)
    • ►  July (2)
    • ►  June (2)
    • ►  March (1)
    • ►  February (1)
  • ►  2018 (15)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (2)
    • ►  August (2)
    • ►  July (3)
    • ►  June (1)
    • ►  April (1)
    • ►  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)
      • Avoiding unnecessary function calls to optimize SQ...
      • Prefer Oracle Native Date Arithmetic over ANSI INT...
    • ►  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)
    • ►  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.