Let's Develop in Oracle


MINUS query giving results on exactly same data in two tables

Steps to debug SQL Performance issue in Oracle Database

Oracle Database 18c XE (Express Edition) is available for download - Top Features

SQLFormat - CSV, JSON, XML - Format output of SQL in SQLDeveloper

NOT IN clause with NULL is tricky in Oracle Database

SQL Puzzle - Transpose Rows and Shift Values among columns

QUERY_REWRITE_ENABLED - ORA-00600 - kglpin-bad-lock - Materialized Views

Why was I able to refresh Invalid MATERIALIZED VIEW in Oracle Database?

Oracle Database 18c (on-premises) is available for download

SQL Loader Express Mode - Loading data in Oracle database can't be more easy

ROUND, TRUNC, CEIL and FLOOR in Oracle Database

Order By and Null values in Oracle Database

ORA-01476: divisor is equal to zero

Top 18 features of Oracle 18c

Oracle Cloud Performance Benchmark by Accenture

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
  • ASP.NET: Email Validation by RegularExpressionValidator
  • Load CSV file in Oracle using PL/SQL
  • Oracle Database 12c New Features for Developers
  • ASP.NET: GridView with Scrollbar
  • Parse JSON data in Oracle Database using JSON_TABLE in SQL
  • Auto Increment Column Performance Enhancement with each Oracle Version
  • FTP File Upload in VB.NET
  • Oracle: Improve Import/ Export performance (imp / exp)
  • ORA-01403: no data found

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)
      • MINUS query giving results on exactly same data in...
    • ►  November (1)
      • Steps to debug SQL Performance issue in Oracle Dat...
    • ►  October (2)
      • Oracle Database 18c XE (Express Edition) is availa...
      • SQLFormat - CSV, JSON, XML - Format output of SQL ...
    • ►  September (2)
      • NOT IN clause with NULL is tricky in Oracle Database
      • SQL Puzzle - Transpose Rows and Shift Values among...
    • ►  August (2)
      • QUERY_REWRITE_ENABLED - ORA-00600 - kglpin-bad-loc...
      • Why was I able to refresh Invalid MATERIALIZED VIE...
    • ►  July (3)
      • Oracle Database 18c (on-premises) is available for...
      • SQL Loader Express Mode - Loading data in Oracle d...
      • ROUND, TRUNC, CEIL and FLOOR in Oracle Database
    • ►  June (1)
      • Order By and Null values in Oracle Database
    • ►  April (1)
      • ORA-01476: divisor is equal to zero
    • ►  March (1)
      • Top 18 features of Oracle 18c
    • ►  February (1)
      • Oracle Cloud Performance Benchmark by Accenture
  • ►  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)
    • ►  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.