Let's Develop in Oracle


Showing posts with label Oracle PL/SQL. Show all posts
Showing posts with label Oracle PL/SQL. Show all posts

Execute Immediate Returning Bulk Collect - Dynamic DML Collection

Get Results from REFCURSOR with unknown number of columns in PLSQL

Auto Increment Column Performance Enhancement with each Oracle Version

Passing Parameter to CURSOR in Oracle

Bulk Collect with Limit Clause and %NOTFOUND

Compare Values of Two Comma Separated Strings in Oracle

Ref Cursor: Strongly Typed VS Weakly Typed

Append String to CLOB in Optimized way

Difference Between Cursor And Ref Cursor

Setting Sequence Value to a Specific Number

One Time Immediate Job in Oracle

Oracle Auto Increment Column - Sequence as Default Value

Load XML File in Oracle Table

Create XML file using PL/SQL

Load CSV file in Oracle using PL/SQL

Compare Structures of Two Tables in Oracle

DBMS_PROFILER: How to analyze pl/sql performance

DBMS_PROFILER: Overview and How to Install

Auditing User Login-Logoff activities using System Level Trigger

New Features for Developers in Oracle 11g

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

  • Oracle - DDL, DML and DCL commands
  • ORA-01157: cannot identify/lock data file string - see DBWR trace file
  • Oracle Database 12c New Features for Developers
  • Load CSV file in Oracle using PL/SQL
  • ORA-00936 missing expression
  • Auto Increment Column Performance Enhancement with each Oracle Version
  • ORA-00911: invalid character
  • ORA-01830 date format picture ends before converting entire input string
  • Parse JSON data in Oracle Database using JSON_TABLE in SQL
  • ORA-03135: connection lost contact

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)
      • Analytical SQL - Running Total - Order by without ...
    • ►  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)
    • ►  November (8)
    • ►  October (22)
Copyright © 2009-2016 | Nimish Garg | All rights reserved.. Powered by Blogger.