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
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 2291 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 3359 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 4361 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 3903 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 3505 Fri, 23 August 2019 01:59
By: vippysharma
  Bursting Program is not being Submitted
By: vharish006 on Wed, 21 August 2019
1 3000 Wed, 21 August 2019 14:58
By: Michel Cadot
  regexp_replace
Oracle 12c
By: sss111ind on Fri, 16 August 2019
6 2247 Tue, 20 August 2019 01:50
By: sss111ind
  xml generation from db
Oracle 12c 2
By: sss111ind on Wed, 14 August 2019
1 1354 Mon, 19 August 2019 03:47
By: sss111ind
  plsql logic
By: yashi7777 on Fri, 16 August 2019
10 1912 Sat, 17 August 2019 10:23
By: Michel Cadot
  Data spliting
11gr2
By: rajeshkr on Mon, 12 August 2019
5 2012 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 1912 Fri, 16 August 2019 06:22
By: Bill B
  SQL Tuning instead of Cross Join
11G
By: laknar on Thu, 25 July 2019
18 3923 Fri, 16 August 2019 05:50
By: Bill B
  REQEXP_SUBTR debug
11i
By: Mani Balan on Thu, 08 August 2019
3 1232 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 1319 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 1418 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 2610 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 4923 Tue, 06 August 2019 12:57
By: Michel Cadot
  Oracle insert statement
Oracle 12
By: anand.doss on Sat, 03 August 2019
2 1220 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 1994 Mon, 05 August 2019 03:00
By: cookiemonster
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
7 2801 Tue, 30 July 2019 02:56
By: Michel Cadot
  Leading zeros in a spool file
By: Mike Bentley on Wed, 20 December 2006
6 6540 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 4179 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 2909 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 1583 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 1180 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 8458 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 1867 Thu, 18 July 2019 14:08
By: Lalit Kumar B
  Sending table data in HTML format through PL/SQL
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
By: NewLife on Fri, 11 July 2008
17 110786 Tue, 16 July 2019 07:51
By: cookiemonster
  MV Refresh On Commit
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 06 June 2019
2 3562 Mon, 15 July 2019 00:39
By: saipradyumn
  Returning into clause for insert selectstatements
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 07 June 2019
6 5527 Mon, 15 July 2019 00:26
By: saipradyumn
  Different Values of RAWTOHEX in Oracle 12c and 11g
Oracle 12.1.0.2.0 and Oracle 11.2.0.1.0 Both Enterprise Editions
By: Manoj.Gupta.91 on Fri, 12 July 2019
3 1391 Fri, 12 July 2019 10:31
By: Michel Cadot
  MAX(DECODE
Oracle 8i, Windows ver 6.1
By: kumarvk on Mon, 08 July 2019
7 2529 Thu, 11 July 2019 06:03
By: cookiemonster
  Trying to Report on Date Periods within a table
Oracle 12C
By: mvs2019 on Sat, 06 July 2019
6 2520 Sun, 07 July 2019 20:48
By: mvs2019
  Automatic abropting the long running job
Oracle 12c
By: sss111ind on Wed, 03 July 2019
8 3401 Sat, 06 July 2019 07:28
By: BlackSwan
  How to Create variable out of Table Type Variable!
By: ramya29p on Mon, 24 June 2019
7 3000 Mon, 24 June 2019 12:38
By: BlackSwan
  Incorrect work of the sql query with JOIN.
Oracle, 11g, Win 7
By: orajav on Thu, 13 June 2019
18 4991 Fri, 14 June 2019 05:50
By: orajav
  Using the Sql query to find employees who were recruited on the same day or on neighboring days.
Oracle, 11g, Win 7
By: orajav on Wed, 12 June 2019
21 6496 Thu, 13 June 2019 12:46
By: orajav
  How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va
oracle 11g
By: Piranava on Mon, 10 June 2019
3 3554 Thu, 13 June 2019 07:24
By: Bill B
  How to build a query that gets its values from a file
Oracle SQL Developer Version 4.0.1.14 / windows 7.0
By: hartyshow@yahoo.fr on Tue, 11 June 2019
10 4068 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 6189 Tue, 11 June 2019 12:35
By: Bill 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: Wed Dec 11 19:02:15 CST 2019