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
  how to get the rows of different values of single column
By: Sekhar6617 on Wed, 21 April 2021
9 13261 Mon, 03 May 2021 07:23
By: Sekhar6617
  sql regex_instr
oracle 11g
By: CindyC on Thu, 29 April 2021
11 15752 Fri, 30 April 2021 16:38
By: CindyC
  substring compare and update
oracle 11g
By: CindyC on Wed, 28 April 2021
0 5684 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 4942 Wed, 28 April 2021 15:03
By: evoradba
  ORA-00979
By: a_naq on Wed, 28 April 2021
5 6357 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 9837 Tue, 27 April 2021 10:14
By: desmond30
  grouping logic
oracle 11g
By: yashi7777 on Sat, 24 April 2021
6 9735 Mon, 26 April 2021 20:01
By: yashi7777
  Listagg over Listagg
Oracle 12g
By: abhayman on Sat, 24 April 2021
2 5955 Sat, 24 April 2021 03:03
By: abhayman
  upper case in create table
By: jchiu183 on Thu, 19 January 2006
6 14931 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 8796 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 15659 Wed, 14 April 2021 23:16
By: Sekhar6617
  ORA-00904: "SUPPID": invalid identifier
oracle
By: whotheunknown on Sat, 10 April 2021
5 10056 Mon, 12 April 2021 18:30
By: EdStevens
  Query to Display date
11g
By: glmjoy on Fri, 09 April 2021
2 11125 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 10879 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 18699 Wed, 07 April 2021 04:49
By: Udays
  Oracle Sql statements
R12
By: Andrescr5 on Mon, 05 April 2021
1 3224 Mon, 05 April 2021 11:41
By: EdStevens
  Query PL/SQL Urgent
By: Vins82 on Fri, 02 April 2021
1 6843 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 7469 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 5114 Wed, 31 March 2021 07:19
By: Heavyd
  query display like aging
11g
By: glmjoy on Tue, 30 March 2021
6 9490 Wed, 31 March 2021 01:15
By: glmjoy
  group by common string
oracle 11g
By: yashi7777 on Wed, 17 March 2021
8 13354 Mon, 29 March 2021 20:49
By: yashi7777
  Analytical functions
By: jay_yan on Mon, 29 March 2021
4 6540 Mon, 29 March 2021 10:30
By: Michel Cadot
  sort with duplicate records
12
By: mape on Sat, 27 March 2021
5 7529 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 9109 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 7893 Wed, 24 March 2021 11:49
By: Michel Cadot
  Generate SQL via SQL
By: mikewazowski on Tue, 23 February 2021
32 18941 Thu, 18 March 2021 03:25
By: Michel Cadot
  Generating Installment rows
12.1.0.1
By: OraFerro on Tue, 16 March 2021
1 10758 Tue, 16 March 2021 23:28
By: OraFerro
  Beginner question. Update query with another SQL
11g
By: RM33 on Sat, 13 March 2021
2 7139 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 11010 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 14916 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 9491 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 8230 Fri, 05 March 2021 00:13
By: rfcl
  schema level dml trigger
oracle 10g
By: pradeep08 on Wed, 03 March 2021
2 6284 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 4853 Wed, 03 March 2021 06:38
By: apisto
  Reading text from binary data in a blob
By: appender on Sat, 27 February 2021
2 8684 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 5349 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 4453 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 19852 Sat, 27 February 2021 18:19
By: Youssef_Tadros
  Auto Sequence number for specific subinventory transactions
By: smk08 on Sat, 27 February 2021
1 7759 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 5951 Fri, 26 February 2021 06:21
By: sss111ind
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: Fri Feb 23 20:14:22 CST 2024