Let's Develop in Oracle


ASP.NET: Encryption and Decryption Base64

Oracle: Comma Separated String To Rows

Validate Dimensions of Uploaded Image : ASP.NET

Oracle: Dates Difference in days, hours, minutes & seconds

Create XML File from a Dataset : ASP.NET

Get Country Name by Client IP

Convert A Number To Month Name and Month Name to Number in ASP.NET

Object Clone using Serialization in ASP.NET

Check if Url Exists or not in ASP.NET

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)
    • ►  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)
    • ►  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)
      • ASP.NET: Encryption and Decryption Base64
      • Oracle: Comma Separated String To Rows
      • Validate Dimensions of Uploaded Image : ASP.NET
      • Oracle: Dates Difference in days, hours, minutes &...
      • Create XML File from a Dataset : ASP.NET
      • Get Country Name by Client IP
      • Convert A Number To Month Name and Month Name to N...
      • Object Clone using Serialization in ASP.NET
      • Check if Url Exists or not in ASP.NET
    • ►  November (8)
    • ►  October (22)
Copyright © 2009-2016 | Nimish Garg | All rights reserved.. Powered by Blogger.