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
  Same record with Space and Without Space
Oracle 12c, Windows NT
By: pstanand on Fri, 29 July 2016
13 960 Sun, 31 July 2016 03:33
By: Barbara Boehmer
  comparison ALL with subquery returns no rows - TRUE
Oracle 11.2.0.3
By: pointers on Fri, 29 July 2016
7 739 Sat, 30 July 2016 03:08
By: Michel Cadot
  how create synonym for full database
By: mfahimaamirgmailcom on Fri, 29 July 2016
7 635 Fri, 29 July 2016 07:54
By: BlackSwan
  place set values next to each other
Oracle 11.2.0.3
By: pointers on Thu, 28 July 2016
4 437 Thu, 28 July 2016 13:47
By: BlackSwan
  Creating different worksheets in a single excel
Oracle 11g
By: venkat111 on Thu, 28 July 2016
2 432 Thu, 28 July 2016 14:15
By: Bill B
  unusable index on inserting data into partition table
Oracle 11.0.2
By: jbvenkat_mcq on Thu, 28 July 2016
3 298 Thu, 28 July 2016 01:03
By: Michel Cadot
  Database vs Tablespace
By: KirkSpiritor on Wed, 27 July 2016
17 891 Fri, 29 July 2016 07:42
By: EdStevens
  how to report oracle internal error
By: desmond30 on Wed, 27 July 2016
4 996 Tue, 02 August 2016 00:24
By: Michel Cadot
  Make use of UNUSABLE_INDEX by uisnh HInt
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Wed, 27 July 2016
4 480 Wed, 03 August 2016 13:37
By: Bill B
  Replace Accented Characters
By: ramya29p on Wed, 27 July 2016
21 782 Wed, 03 August 2016 05:12
By: Michel Cadot
icon5.gif Error An INTO Clause
Oracle, Toad, SQL Developer, Windows Server
By: abacusdotcom on Tue, 26 July 2016
6 695 Mon, 01 August 2016 06:53
By: EdStevens
  Retrieve text for ID from another table for two columns in a SELECT statement
Oracle 11.2.0.3.0 , OEL 5
By: Andrey_R on Tue, 26 July 2016
4 402 Tue, 26 July 2016 10:35
By: John Watson
  XML tag selection
ORACLE 11g
By: lokimisc on Tue, 26 July 2016
8 840 Wed, 27 July 2016 02:09
By: pablolee
  LAG error
10g, 8i, win 8.1
By: rzkhan on Mon, 25 July 2016
8 613 Mon, 25 July 2016 07:35
By: rzkhan
  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 898 Mon, 25 July 2016 15:00
By: Bill B
  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 449 Sun, 24 July 2016 14:55
By: Andrey_R
  SQL query for formatted data display
oracle, 11gR2, RHEL
By: 9390512774 on Fri, 22 July 2016
2 679 Fri, 22 July 2016 13:40
By: Solomon Yakobson
  GETTING NULLS WHEN USING PIVOT
By: vijay1255 on Thu, 21 July 2016
6 696 Fri, 22 July 2016 10:24
By: Bill B
  ORA-01006
ORA-01006: la variable attachée (bind variable) n'existe pas
By: pcouas on Wed, 20 July 2016
5 722 Thu, 21 July 2016 04:50
By: pcouas
  Extract value from xml
Oracle 12c
By: Raj12345 on Thu, 28 July 2016
3 415 Thu, 28 July 2016 14:12
By: Bill B
  Getting Parent and Child from the same table & same column
Oracle 11g/Windows 8.1
By: naveenjv on Wed, 20 July 2016
6 510 Thu, 21 July 2016 06:23
By: naveenjv
icon5.gif Deadlock experienced but Blocking lock expected
12.1.0.2
By: epep-pdm on Wed, 20 July 2016
7 718 Thu, 21 July 2016 12:20
By: Solomon Yakobson
  Logic for displaying below row as first row
Oracle 10g
By: sss111ind on Tue, 19 July 2016
12 659 Thu, 21 July 2016 02:20
By: sss111ind
  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 492 Tue, 19 July 2016 07:31
By: saipavan.plsql
  Collection Last Record
Oracle 11g
By: ORAGENASHOK on Mon, 18 July 2016
4 550 Wed, 20 July 2016 03:05
By: cookiemonster
  Change Current schema to other schema
Oracle 11g, windows
By: Vijay55 on Mon, 18 July 2016
2 428 Mon, 18 July 2016 03:54
By: flyboy
  heirarchy between tables
By: 17111991 on Sun, 17 July 2016
1 294 Sun, 17 July 2016 12:38
By: Michel Cadot
  Table joining
Windows
By: 17111991 on Sun, 17 July 2016
4 554 Sun, 17 July 2016 23:44
By: Barbara Boehmer
  Merging BLOB
Oracle 11GR2, Windows Server 2008 R2
By: Jaffat1982 on Wed, 13 July 2016
6 766 Tue, 19 July 2016 08:00
By: Jaffat1982
  Parent child count?
By: P1Oracle on Tue, 12 July 2016
6 553 Wed, 13 July 2016 03:36
By: cookiemonster
  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 1057 Fri, 15 July 2016 14:45
By: Michel Cadot
  finding constrains on table
oracle 12c
By: gorants on Mon, 11 July 2016
15 764 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 498 Mon, 11 July 2016 17:52
By: Barbara Boehmer
  information
oracle 8
By: ceciaide on Fri, 08 July 2016
12 908 Mon, 11 July 2016 16:32
By: ceciaide
  Unpivot Query Help to transpose the data
Oracle 11g
By: arifs3738 on Sat, 16 July 2016
2 427 Sun, 17 July 2016 12:19
By: arifs3738
  Distinct Comma Separated Values
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Tue, 05 July 2016
9 2789 Wed, 28 September 2016 06:15
By: Xandot
  query doubt
hp unix, oracle 10g
By: arun888 on Mon, 04 July 2016
4 584 Tue, 05 July 2016 00:43
By: arun888
  Procidure includ not duplicate
By: rkled on Mon, 04 July 2016
3 443 Mon, 04 July 2016 09:29
By: Michel Cadot
  Oracle reports
Oracle 11g
By: srinivas.k2005 on Mon, 04 July 2016
7 733 Tue, 05 July 2016 05:02
By: Michel Cadot
  Constraints in External Table.
Oracle 11g
By: jeeva7311 on Mon, 04 July 2016
4 425 Mon, 04 July 2016 10:13
By: jeeva7311
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 Sep 19 10:06:10 CDT 2017

Total time taken to generate the page: 0.01592 seconds