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
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 2196 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 3519 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 3658 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 3711 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 4648 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 1345 Mon, 09 September 2019 14:14
By: fabissilva
  BI Publisher Apex web Services
Oracle 11g
By: akarra on Mon, 09 September 2019
1 1514 Mon, 09 September 2019 12:59
By: akarra
  IIF and Oracle
Windows 2003 and Oracle 10g
By: aijaz786 on Thu, 18 February 2010
16 13920 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 4548 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 4044 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 4217 Fri, 30 August 2019 13:47
By: nareshk00
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
22 10593 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 2108 Thu, 29 August 2019 11:45
By: wtolentino
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 2995 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 4116 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 5035 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 4632 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 4342 Fri, 23 August 2019 01:59
By: vippysharma
  Bursting Program is not being Submitted
By: vharish006 on Wed, 21 August 2019
1 3475 Wed, 21 August 2019 14:58
By: Michel Cadot
  regexp_replace
Oracle 12c
By: sss111ind on Fri, 16 August 2019
6 2948 Tue, 20 August 2019 01:50
By: sss111ind
  xml generation from db
Oracle 12c 2
By: sss111ind on Wed, 14 August 2019
1 1826 Mon, 19 August 2019 03:47
By: sss111ind
  plsql logic
By: yashi7777 on Fri, 16 August 2019
10 2964 Sat, 17 August 2019 10:23
By: Michel Cadot
  Data spliting
11gr2
By: rajeshkr on Mon, 12 August 2019
5 2834 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 2680 Fri, 16 August 2019 06:22
By: Bill B
  SQL Tuning instead of Cross Join
11G
By: laknar on Thu, 25 July 2019
18 5975 Fri, 16 August 2019 05:50
By: Bill B
  REQEXP_SUBTR debug
11i
By: Mani Balan on Thu, 08 August 2019
3 1980 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 1968 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 2237 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 3860 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 6382 Tue, 06 August 2019 12:57
By: Michel Cadot
  Oracle insert statement
Oracle 12
By: anand.doss on Sat, 03 August 2019
2 1816 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 3083 Mon, 05 August 2019 03:00
By: cookiemonster
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
7 3457 Tue, 30 July 2019 02:56
By: Michel Cadot
  Leading zeros in a spool file
By: Mike Bentley on Wed, 20 December 2006
6 7686 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 5887 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 4034 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 2245 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 1776 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 10540 Mon, 22 July 2019 07:52
By: EdStevens
  ALTER INDEX To Add the Extra columns
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 12 July 2019
5 2549 Thu, 18 July 2019 14:08
By: Lalit Kumar B
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 Aug 13 09:42:53 CDT 2020