Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
1 19829 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 255975 Tue, 06 November 2018 14:17
By: Solomon Yakobson
ORA-24373 invalid length specified for statement (spllt) has been moved to Client Tools by the moderator.
  Nested Queries with Select Statement
Oracle 12 c, 12.1.0.1
By: a_naq on Mon, 10 May 2021
5 1331 Mon, 10 May 2021 11:56
By: Michel Cadot
  Optimization of SQL
12.2
By: swasora on Sun, 09 May 2021
2 3440 Sun, 09 May 2021 06:55
By: Solomon Yakobson
  Timezone Europe/Paris
10GR1 HPUX
By: davy7887 on Fri, 07 May 2021
3 5842 Fri, 07 May 2021 19:35
By: Solomon Yakobson
icon5.gif multiple queries and 1 output window/result
Oracle SQL Developer 19.1.0.094 / Oracle Database 12.2.0.1.0
By: abenitez77 on Mon, 03 May 2021
6 5645 Mon, 03 May 2021 12:08
By: Michel Cadot
  how to get the rows of different values of single column
By: Sekhar6617 on Wed, 21 April 2021
9 8067 Mon, 03 May 2021 07:23
By: Sekhar6617
  sql regex_instr
oracle 11g
By: CindyC on Thu, 29 April 2021
11 9416 Fri, 30 April 2021 16:38
By: CindyC
  substring compare and update
oracle 11g
By: CindyC on Wed, 28 April 2021
0 3164 Wed, 28 April 2021 15:33
By: CindyC
  how to change a column to a virtual
Linux RDBMS 12c
By: evoradba on Wed, 28 April 2021
2 2007 Wed, 28 April 2021 15:03
By: evoradba
  ORA-00979
By: a_naq on Wed, 28 April 2021
5 2125 Wed, 28 April 2021 12:23
By: Solomon Yakobson
  pipeline function call in a stored proc and loop
By: desmond30 on Mon, 26 April 2021
8 4518 Tue, 27 April 2021 10:14
By: desmond30
  grouping logic
oracle 11g
By: yashi7777 on Sat, 24 April 2021
6 6002 Mon, 26 April 2021 20:01
By: yashi7777
  Listagg over Listagg
Oracle 12g
By: abhayman on Sat, 24 April 2021
2 2583 Sat, 24 April 2021 03:03
By: abhayman
  upper case in create table
By: jchiu183 on Thu, 19 January 2006
6 8477 Sun, 18 April 2021 05:00
By: Michel Cadot
  Hierarchy again and again and again !
11.2.0.3
By: Amine on Wed, 14 April 2021
3 5428 Thu, 15 April 2021 05:02
By: Michel Cadot
  how to remove html tags from the text
By: Sekhar6617 on Thu, 08 April 2021
8 9487 Wed, 14 April 2021 23:16
By: Sekhar6617
  ORA-00904: "SUPPID": invalid identifier
oracle
By: whotheunknown on Sat, 10 April 2021
5 6331 Mon, 12 April 2021 18:30
By: EdStevens
  Query to Display date
11g
By: glmjoy on Fri, 09 April 2021
2 8468 Fri, 09 April 2021 07:14
By: glmjoy
  Mark Only Selected Portion of a Column Data
12.1
By: azeem87 on Thu, 08 April 2021
4 7532 Fri, 09 April 2021 00:20
By: Michel Cadot
  Display zero if negative value.
Oracle 8i, Windows Server 2003
By: kumarvk on Mon, 09 January 2012
3 12892 Wed, 07 April 2021 04:49
By: Udays
  Oracle Sql statements
R12
By: Andrescr5 on Mon, 05 April 2021
1 721 Mon, 05 April 2021 11:41
By: EdStevens
  Query PL/SQL Urgent
By: Vins82 on Fri, 02 April 2021
1 4045 Fri, 02 April 2021 03:56
By: Michel Cadot
  filtering for records based on select criteria
oracle plsql
By: padler on Wed, 31 March 2021
2 4600 Thu, 01 April 2021 09:23
By: John Watson
  Disperse credit notes between groups of invoices
Oracle12c Release 12.1.0.2.0
By: Heavyd on Wed, 31 March 2021
1 2945 Wed, 31 March 2021 07:19
By: Heavyd
  query display like aging
11g
By: glmjoy on Tue, 30 March 2021
6 5987 Wed, 31 March 2021 01:15
By: glmjoy
  group by common string
oracle 11g
By: yashi7777 on Wed, 17 March 2021
8 10224 Mon, 29 March 2021 20:49
By: yashi7777
  Analytical functions
By: jay_yan on Mon, 29 March 2021
4 3348 Mon, 29 March 2021 10:30
By: Michel Cadot
  sort with duplicate records
12
By: mape on Sat, 27 March 2021
5 4321 Sun, 28 March 2021 12:01
By: mape
  12.1.0.1
Filter dates between a list of start and end dates
By: OraFerro on Thu, 25 March 2021
2 6545 Sat, 27 March 2021 23:25
By: OraFerro
  how to use select field value in where clause (merged)
By: Sekhar6617 on Wed, 24 March 2021
2 5375 Wed, 24 March 2021 11:49
By: Michel Cadot
  Generate SQL via SQL
By: mikewazowski on Tue, 23 February 2021
32 12725 Thu, 18 March 2021 03:25
By: Michel Cadot
  Generating Installment rows
12.1.0.1
By: OraFerro on Tue, 16 March 2021
1 8209 Tue, 16 March 2021 23:28
By: OraFerro
  Beginner question. Update query with another SQL
11g
By: RM33 on Sat, 13 March 2021
2 4490 Sun, 14 March 2021 06:10
By: Littlefoot
  Parsing XML multiple CDATA with & and withoutn &
Oracle 12c 2
By: sss111ind on Sun, 07 March 2021
3 7339 Mon, 08 March 2021 04:17
By: Solomon Yakobson
  Need help on Tabibitosan (start of group)
11.2.0.3
By: Amine on Fri, 05 March 2021
16 9929 Sat, 06 March 2021 16:49
By: Amine
  Setting up Email service on Oracle 9i
Oracle Database 9i
By: rfcl on Thu, 04 March 2021
9 5732 Fri, 05 March 2021 00:54
By: Michel Cadot
icon5.gif How to call/execute a visual basic script using PL / SQL
oracle db v9i
By: rfcl on Thu, 04 March 2021
2 5961 Fri, 05 March 2021 00:13
By: rfcl
  schema level dml trigger
oracle 10g
By: pradeep08 on Wed, 03 March 2021
2 3984 Thu, 04 March 2021 12:32
By: EdStevens
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Tue May 11 20:13:41 CDT 2021