Let's Develop in Oracle


Showing posts with label Connect By. Show all posts
Showing posts with label Connect By. Show all posts

Graph Shortest Path Solution by SQL

Alpha Numeric Counter Or Sequence

Oracle: Fibonacci Series by SQL

Oracle SQL: Triangular Series (1 3 6 10 15 21)

Oracle: Comma Separated String To Rows 10g Onwards

Oracle: Nth Record from Comma Separated String

Oracle: Department wise Employee Ids Comma Separated (Analytical Functions )

Oracle: Connect By Prior (Hierarchical Query)

Oracle: Get All Month or Week Days Names

Oracle: Comma Separated String To Rows

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-03135: connection lost contact
  • ORA-01157: cannot identify/lock data file string - see DBWR trace file
  • Load CSV file in Oracle using PL/SQL
  • Convert XML to Rows and Columns in Oracle
  • Parse JSON data in Oracle Database using JSON_TABLE in SQL
  • Auto Increment Column Performance Enhancement with each Oracle Version
  • Oracle: DBMS_STATS Gather Statistics of Schema, Tables, Indexes
  • Oracle: String to Date, Timestamp with Timezone
  • Analytical SQL - Running Total - Order by without Partition By
  • ORA-28002: the password will expire within 7 days

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.