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
  Sql query to group the values in comma seperated values
Oracle DB 10.2.0.2
By: wantmannu on Wed, 11 September 2019
4 3109 Thu, 12 September 2019 10:13
By: Michel Cadot
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 2944 Thu, 12 September 2019 06:26
By: sss111ind
  View not pulling with updated table information
APEX Oracle -PL/SQL
By: WillJ on Tue, 10 September 2019
8 4717 Wed, 11 September 2019 07:28
By: WillJ
  How To Show Column Value separated with colon as well as another column vlaue
Oracle 11G
By: ssyr on Tue, 10 September 2019
6 4733 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 4788 Tue, 10 September 2019 06:25
By: getideas456@gmail.com
  ORA-00001: unique constraint On Merge Insert
Oracle11g
By: ssyr on Fri, 30 August 2019
7 5571 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 2181 Mon, 09 September 2019 14:14
By: fabissilva
  BI Publisher Apex web Services
Oracle 11g
By: akarra on Mon, 09 September 2019
1 2866 Mon, 09 September 2019 12:59
By: akarra
  IIF and Oracle
Windows 2003 and Oracle 10g
By: aijaz786 on Thu, 18 February 2010
16 15413 Fri, 06 September 2019 08:32
By: EdStevens
  ORA-29913 ORA-29400 KUP-00554
Oracle 12c
By: kavitha.raj23 on Tue, 03 September 2019
6 6732 Wed, 04 September 2019 06:40
By: EdStevens
  ORA-04068: existing state of packages has been discarded
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat
By: fixxxer on Fri, 30 August 2019
4 6022 Mon, 02 September 2019 05:24
By: fixxxer
  How to remove ordinal suffixes after the numbers
pl/sql developer, windows 10
By: nareshk00 on Thu, 29 August 2019
10 5459 Fri, 30 August 2019 13:47
By: nareshk00
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
22 12515 Fri, 30 August 2019 02:01
By: oracledev
  Additional Column Indicator for Failed or Passed
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: wtolentino on Thu, 29 August 2019
2 2946 Thu, 29 August 2019 11:45
By: wtolentino
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 3757 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 5190 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 5898 Wed, 28 August 2019 00:33
By: Michel Cadot
icon5.gif Compare two tables to find new/modified/removed records
Oracle DB 11g Enterprise Edition 11.2.0.4.0 - 64bit / Windows 7 x64
By: nickz on Thu, 22 August 2019
3 5496 Fri, 23 August 2019 09:12
By: Bill B
  Dynamic Logic
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: vippysharma on Tue, 20 August 2019
5 5207 Fri, 23 August 2019 01:59
By: vippysharma
  Bursting Program is not being Submitted
By: vharish006 on Wed, 21 August 2019
1 4256 Wed, 21 August 2019 14:58
By: Michel Cadot
  regexp_replace
Oracle 12c
By: sss111ind on Fri, 16 August 2019
6 3813 Tue, 20 August 2019 01:50
By: sss111ind
  xml generation from db
Oracle 12c 2
By: sss111ind on Wed, 14 August 2019
1 2635 Mon, 19 August 2019 03:47
By: sss111ind
  plsql logic
By: yashi7777 on Fri, 16 August 2019
10 3928 Sat, 17 August 2019 10:23
By: Michel Cadot
  Data spliting
11gr2
By: rajeshkr on Mon, 12 August 2019
5 3650 Fri, 16 August 2019 08:46
By: rajeshkr
icon3.gif Materialized View Query
Oracle SQL Developer 4.2.0
By: baboyjames on Thu, 25 July 2019
3 3574 Fri, 16 August 2019 06:22
By: Bill B
  SQL Tuning instead of Cross Join
11G
By: laknar on Thu, 25 July 2019
18 7360 Fri, 16 August 2019 05:50
By: Bill B
  REQEXP_SUBTR debug
11i
By: Mani Balan on Thu, 08 August 2019
3 2943 Tue, 13 August 2019 14:15
By: Michel Cadot
  Union and sort the data based on date range
11G
By: laknar on Wed, 07 August 2019
2 2760 Thu, 08 August 2019 00:41
By: Michel Cadot
  Comprimir una imagen utilizando AS_ZIP
Oracle Database 11g Release 11.2.0.4.0
By: Bartholomew Kuma on Wed, 07 August 2019
3 3372 Thu, 08 August 2019 00:38
By: Michel Cadot
  Is it possible to insert a folder from a directory into a table?
Oracle Data Base 11g r2
By: Bartholomew Kuma on Mon, 05 August 2019
12 4982 Thu, 08 August 2019 00:37
By: Michel Cadot
icon1.gif read and validate file
Oracle Data Base 11g r2
By: Bartholomew Kuma on Tue, 19 March 2019
13 7885 Tue, 06 August 2019 12:57
By: Michel Cadot
  Oracle insert statement
Oracle 12
By: anand.doss on Sat, 03 August 2019
2 2716 Mon, 05 August 2019 07:35
By: Bill B
  Stored Procedures compile in 11G but do not in 12C (12.1.0.1.0)
Oracle 12.1.0.1.0 on a Windows 10
By: ALONG on Thu, 01 August 2019
8 4234 Mon, 05 August 2019 03:00
By: cookiemonster
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
7 4534 Tue, 30 July 2019 02:56
By: Michel Cadot
  Leading zeros in a spool file
By: Mike Bentley on Wed, 20 December 2006
6 9523 Mon, 29 July 2019 09:00
By: Bill B
  Load multiline data in table using sql loader
Oracle 12c
By: adfire05 on Mon, 15 July 2019
14 7632 Fri, 26 July 2019 12:31
By: adfire05
  Select query took too long to execute on one schema but very little time on another scema
oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM
By: janakors on Wed, 24 July 2019
16 5330 Fri, 26 July 2019 07:42
By: Michel Cadot
  How to use sysdate as a column header
Oracle 11g
By: chintan.patel on Wed, 24 July 2019
5 3343 Thu, 25 July 2019 07:39
By: Solomon Yakobson
  Case insensitive in oracle 12c
RDBMS 12.2..0.1 on linux
By: evoradba on Wed, 24 July 2019
1 2810 Wed, 24 July 2019 14:16
By: Michel Cadot
  How to get the file name from directory
Oracle 10g
By: sss111ind on Wed, 12 December 2012
15 12880 Mon, 22 July 2019 07:52
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: Mon Dec 06 21:48:47 CST 2021