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
  Mark Only Selected Portion of a Column Data
12.1
By: azeem87 on Thu, 08 April 2021
4 8580 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 14717 Wed, 07 April 2021 04:49
By: Udays
  Oracle Sql statements
R12
By: Andrescr5 on Mon, 05 April 2021
1 1626 Mon, 05 April 2021 11:41
By: EdStevens
  Query PL/SQL Urgent
By: Vins82 on Fri, 02 April 2021
1 4995 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 5511 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 3773 Wed, 31 March 2021 07:19
By: Heavyd
  query display like aging
11g
By: glmjoy on Tue, 30 March 2021
6 7103 Wed, 31 March 2021 01:15
By: glmjoy
  group by common string
oracle 11g
By: yashi7777 on Wed, 17 March 2021
8 11254 Mon, 29 March 2021 20:49
By: yashi7777
  Analytical functions
By: jay_yan on Mon, 29 March 2021
4 4225 Mon, 29 March 2021 10:30
By: Michel Cadot
  sort with duplicate records
12
By: mape on Sat, 27 March 2021
5 5147 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 7303 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 6153 Wed, 24 March 2021 11:49
By: Michel Cadot
  Generate SQL via SQL
By: mikewazowski on Tue, 23 February 2021
32 14014 Thu, 18 March 2021 03:25
By: Michel Cadot
  Generating Installment rows
12.1.0.1
By: OraFerro on Tue, 16 March 2021
1 9029 Tue, 16 March 2021 23:28
By: OraFerro
  Beginner question. Update query with another SQL
11g
By: RM33 on Sat, 13 March 2021
2 5317 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 8161 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 10979 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 6624 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 6658 Fri, 05 March 2021 00:13
By: rfcl
  schema level dml trigger
oracle 10g
By: pradeep08 on Wed, 03 March 2021
2 4596 Thu, 04 March 2021 12:32
By: EdStevens
  Oracle: sql update on field containing sql itself
Oracle Database 11g
By: apisto on Wed, 03 March 2021
2 3125 Wed, 03 March 2021 06:38
By: apisto
  Reading text from binary data in a blob
By: appender on Sat, 27 February 2021
2 6826 Tue, 02 March 2021 11:29
By: Michel Cadot
  Group result set in a count of 5 records.
By: Heavyd on Mon, 22 February 2021
8 2807 Tue, 02 March 2021 08:12
By: Heavyd
  Comparing input values with table data
Oracle 19c Enterprise Edition Release 19.0.0.0
By: kumarravik on Tue, 02 March 2021
1 2933 Tue, 02 March 2021 06:01
By: Michel Cadot
  remove comments from all_source output
10g r2
By: Kevin Meade on Thu, 27 March 2008
15 16164 Sat, 27 February 2021 18:19
By: Youssef_Tadros
  Auto Sequence number for specific subinventory transactions
By: smk08 on Sat, 27 February 2021
1 6384 Sat, 27 February 2021 02:16
By: Michel Cadot
  call sql server procedure from oracle
Oracle 12c 2
By: sss111ind on Fri, 26 February 2021
0 4857 Fri, 26 February 2021 06:21
By: sss111ind
  Generate month wise data using SQL (Sort data based on month)
Oracle DB 11g Release 11.2.0.2.0
By: chauhanrahul780@yahoo.com on Mon, 22 February 2021
1 1662 Tue, 23 February 2021 00:17
By: Michel Cadot
  A full outer join query
11.2.0.3
By: Amine on Sun, 21 February 2021
2 1642 Mon, 22 February 2021 14:16
By: Amine
  Duplicate Records in output file
Oracle, SQL Plus
By: srai.bi on Tue, 16 February 2021
4 3205 Mon, 22 February 2021 05:15
By: srai.bi
  convert char to number
Oracle 12.1.0.2.0
By: mape on Mon, 22 February 2021
4 1478 Mon, 22 February 2021 05:13
By: Michel Cadot
  Space is replaced by xA0 in SQL Query
Oracle 12g, SQL Plus
By: srai.bi on Thu, 18 February 2021
5 3375 Sun, 21 February 2021 16:29
By: srai.bi
  Assigning one nested table to other in same position
Oracle 12c 2
By: sss111ind on Sat, 20 February 2021
4 1871 Sun, 21 February 2021 16:07
By: Solomon Yakobson
  Trigger on Table (4 merged)
Oracle 19C database
By: ettentrala on Fri, 19 February 2021
5 3288 Sat, 20 February 2021 01:28
By: John Watson
  postgres Range Type equivalent in oracle.
Oracle19c
By: Shrin on Thu, 18 February 2021
4 3222 Thu, 18 February 2021 11:20
By: Michel Cadot
icon9.gif How to show records on zero on hand (Job pick list)
EBiz, 11.5.10.2
By: jasmine.hue on Mon, 22 September 2008
11 7099 Wed, 17 February 2021 12:16
By: pablolee
  date validation
OS
By: suji6281 on Fri, 01 March 2019
15 7993 Sun, 14 February 2021 08:53
By: EdStevens
  Max value row and lookup value
By: suji6281 on Wed, 10 February 2021
4 3095 Wed, 10 February 2021 17:24
By: suji6281
  Parse Json using Oracle SQL
Oracle DB version 12.1.02
By: Shre on Fri, 05 February 2021
5 4781 Mon, 08 February 2021 03:22
By: Shre
  Regexp_like
Oracle 12c, Win 10
By: rajivn786 on Fri, 05 February 2021
8 4354 Sat, 06 February 2021 01:43
By: Michel Cadot
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: Thu Oct 21 09:50:30 CDT 2021