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
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 3112 Mon, 05 September 2011 02:20
By: Littlefoot
  How can I load 300k of data into a CLOB
OEL 5, Oracle 11.2.0.3.0
By: Andrey_R on Sun, 24 July 2016
13 483 Mon, 25 July 2016 15:00
By: Bill B
  LAG error
10g, 8i, win 8.1
By: rzkhan on Mon, 25 July 2016
8 265 Mon, 25 July 2016 07:35
By: rzkhan
  Break a > 300k CLOB string into 32k chunks
OEL 5, Oracle 11.2.0.3.0
By: Andrey_R on Sun, 24 July 2016
10 217 Sun, 24 July 2016 14:55
By: Andrey_R
  Count group data
12.1.0.2
By: bdtran on Sat, 02 July 2016
20 1467 Sat, 23 July 2016 15:24
By: Barbara Boehmer
  Set a range into in time
Forms,
By: Salehin on Tue, 07 June 2016
32 1265 Sat, 23 July 2016 06:54
By: BlackSwan
  SQL query for formatted data display
oracle, 11gR2, RHEL
By: 9390512774 on Fri, 22 July 2016
2 400 Fri, 22 July 2016 13:40
By: Solomon Yakobson
  GETTING NULLS WHEN USING PIVOT
By: vijay1255 on Thu, 21 July 2016
6 344 Fri, 22 July 2016 10:24
By: Bill B
icon5.gif Deadlock experienced but Blocking lock expected
12.1.0.2
By: epep-pdm on Wed, 20 July 2016
7 400 Thu, 21 July 2016 12:20
By: Solomon Yakobson
  Getting Parent and Child from the same table & same column
Oracle 11g/Windows 8.1
By: naveenjv on Wed, 20 July 2016
6 284 Thu, 21 July 2016 06:23
By: naveenjv
  ORA-01006
ORA-01006: la variable attachée (bind variable) n'existe pas
By: pcouas on Wed, 20 July 2016
5 261 Thu, 21 July 2016 04:50
By: pcouas
  Logic for displaying below row as first row
Oracle 10g
By: sss111ind on Tue, 19 July 2016
12 433 Thu, 21 July 2016 02:20
By: sss111ind
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
21 1724 Wed, 20 July 2016 07:19
By: SheliaWilson
  Collection Last Record
Oracle 11g
By: ORAGENASHOK on Mon, 18 July 2016
4 284 Wed, 20 July 2016 03:05
By: cookiemonster
  Merging BLOB
Oracle 11GR2, Windows Server 2008 R2
By: Jaffat1982 on Wed, 13 July 2016
6 392 Tue, 19 July 2016 08:00
By: Jaffat1982
  sorting order need to be done when the columns in the order by are given in input parameter
11 g
By: saipavan.plsql on Mon, 18 July 2016
5 286 Tue, 19 July 2016 07:31
By: saipavan.plsql
  transposing of data in oracle
oracle 12 c
By: tolupuluri on Tue, 28 June 2016
23 1235 Tue, 19 July 2016 03:49
By: Michel Cadot
  Change Current schema to other schema
Oracle 11g, windows
By: Vijay55 on Mon, 18 July 2016
2 192 Mon, 18 July 2016 03:54
By: flyboy
  Table joining
Windows
By: 17111991 on Sun, 17 July 2016
4 361 Sun, 17 July 2016 23:44
By: Barbara Boehmer
  heirarchy between tables
By: 17111991 on Sun, 17 July 2016
1 139 Sun, 17 July 2016 12:38
By: Michel Cadot
  Unpivot Query Help to transpose the data
Oracle 11g
By: arifs3738 on Sat, 16 July 2016
2 239 Sun, 17 July 2016 12:19
By: arifs3738
  ORA-01722 when returning ROWTYPE in function
oracle Database 11g Enterprise Edition Release 11.1.0.6.0
By: rkhatiwala on Tue, 12 July 2016
13 766 Fri, 15 July 2016 14:45
By: Michel Cadot
  Parent child count?
By: thiruvari on Tue, 12 July 2016
6 388 Wed, 13 July 2016 03:36
By: cookiemonster
  PLS-00907: cannot load libraryunit PROD.DAILY_RPT (referenced by )
11G
By: venkat111 on Fri, 01 July 2016
6 478 Tue, 12 July 2016 13:40
By: Bill B
  finding constrains on table
oracle 12c
By: gorants on Mon, 11 July 2016
15 501 Tue, 12 July 2016 02:20
By: Michel Cadot
  Query: select id where max(value) - possible?
Oracle
By: ich01 on Mon, 11 July 2016
10 282 Mon, 11 July 2016 17:52
By: Barbara Boehmer
  information
oracle 8
By: ceciaide on Fri, 08 July 2016
12 597 Mon, 11 July 2016 16:32
By: ceciaide
  PL/SQL error
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
By: jcasas on Sat, 09 July 2016
11 587 Sat, 09 July 2016 21:09
By: Barbara Boehmer
  Distinct Comma Separated Values
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Tue, 05 July 2016
8 636 Thu, 07 July 2016 11:53
By: live4learn
  How to display report format data
Oracle 11
By: ssyr22 on Thu, 30 June 2016
28 1209 Wed, 06 July 2016 19:42
By: Barbara Boehmer
  Oracle reports
Oracle 11g
By: srinivas.k2005 on Mon, 04 July 2016
7 473 Tue, 05 July 2016 05:02
By: Michel Cadot
  query doubt
hp unix, oracle 10g
By: arun888 on Mon, 04 July 2016
4 347 Tue, 05 July 2016 00:43
By: arun888
  SQL problem - variation on top-n-of-group. DDL and DML supplied.
Oracle - any version this millenium, also MySQL and PostgreSQL.
By: ellenall on Sat, 02 July 2016
5 470 Mon, 04 July 2016 17:20
By: Barbara Boehmer
  String Manipulations
Oracle 11g R2
By: javed.khan on Mon, 04 July 2016
1 257 Mon, 04 July 2016 13:36
By: Michel Cadot
  Pick One : A Query for Multiple Submission of form but to take only first one.
Oracle 11g R2
By: javed.khan on Tue, 28 June 2016
11 422 Mon, 04 July 2016 13:13
By: Michel Cadot
  Constraints in External Table.
Oracle 11g
By: jeeva7311 on Mon, 04 July 2016
4 276 Mon, 04 July 2016 10:13
By: jeeva7311
  Procidure includ not duplicate
By: rkled on Mon, 04 July 2016
3 252 Mon, 04 July 2016 09:29
By: Michel Cadot
  Updating Status W to A
SQL
By: Salehin on Tue, 31 May 2016
28 1256 Mon, 04 July 2016 02:59
By: cookiemonster
  PLSQL grant script not working correctly
12c
By: ICB555 on Fri, 01 July 2016
5 319 Mon, 04 July 2016 02:56
By: cookiemonster
  First business day of a given month
Oracle 10g
By: sidh_z on Mon, 06 December 2010
24 4936 Fri, 01 July 2016 12:10
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: Tue Jul 26 01:52:52 CDT 2016

Total time taken to generate the page: 0.09972 seconds