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
  Repeat data based on count column
Oracle 11g Release 2, Linux
By: anil_mk on Thu, 11 August 2016
5 553 Fri, 12 August 2016 07:23
By: anil_mk
  Need to Retrieve data from JSON file in Oracle sql select query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 11 August 2016
9 841 Wed, 17 August 2016 04:20
By: Michel Cadot
  Dynamic Update statement Error
Oracle 9i
By: cvs_1984 on Thu, 11 August 2016
2 497 Thu, 11 August 2016 05:31
By: cvs_1984
  Dynamic SQL Learning
11g
By: Irish88 on Wed, 10 August 2016
7 743 Thu, 18 August 2016 12:10
By: Irish88
  PLS-00231:
By: desmond30 on Mon, 15 August 2016
7 801 Tue, 16 August 2016 08:08
By: Michel Cadot
  Query help
Oracle 12.1.0.2.0, Linux
By: sspn2010 on Mon, 08 August 2016
6 652 Tue, 09 August 2016 16:21
By: sspn2010
  UTL_DBWS error: ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist
Oracle DB, 10g R2, Windows Server 2008R2
By: mdsirajoddin on Sat, 06 August 2016
12 2351 Sat, 06 August 2016 10:38
By: Michel Cadot
  Regular expression search
By: saipradyumn on Fri, 05 August 2016
2 416 Fri, 05 August 2016 07:58
By: Solomon Yakobson
  Sum from part of coloumn
Oracle,11g Release 11.2.0.4.0, Solaris 11
By: nms123 on Fri, 05 August 2016
2 484 Fri, 05 August 2016 09:47
By: nms123
  Help using regexp_substr - Urgent Help needed
Oracle 11
By: Member2014 on Thu, 04 August 2016
8 674 Fri, 05 August 2016 08:41
By: Member2014
  ORA-01917 ERROR
By: mfahimaamirgmailcom on Thu, 18 August 2016
2 534 Thu, 18 August 2016 06:11
By: Michel Cadot
  Check if value EXISTS in plsql table of record type
11G
By: harshadsp on Wed, 03 August 2016
11 1171 Mon, 08 August 2016 05:57
By: harshadsp
  Execution of Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 02 August 2016
4 456 Tue, 02 August 2016 07:51
By: John Watson
  SQL connectivity test
oracle, 11g, AIX
By: Prathikesh on Sat, 06 August 2016
24 859 Mon, 08 August 2016 02:50
By: cookiemonster
  Sorting
12c
By: ashlythomas on Sun, 31 July 2016
6 689 Mon, 01 August 2016 08:05
By: pablolee
  Same record with Space and Without Space
Oracle 12c, Windows NT
By: pstanand on Fri, 29 July 2016
13 1015 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 773 Sat, 30 July 2016 03:08
By: Michel Cadot
  how create synonym for full database
By: mfahimaamirgmailcom on Fri, 29 July 2016
7 677 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 465 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 464 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 318 Thu, 28 July 2016 01:03
By: Michel Cadot
  Database vs Tablespace
By: KirkSpiritor on Wed, 27 July 2016
17 949 Fri, 29 July 2016 07:42
By: EdStevens
  how to report oracle internal error
By: desmond30 on Wed, 27 July 2016
4 1084 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 523 Wed, 03 August 2016 13:37
By: Bill B
  Replace Accented Characters
By: ramya29p on Wed, 27 July 2016
21 857 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 741 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 437 Tue, 26 July 2016 10:35
By: John Watson
  XML tag selection
ORACLE 11g
By: lokimisc on Tue, 26 July 2016
8 986 Wed, 27 July 2016 02:09
By: pablolee
  LAG error
10g, 8i, win 8.1
By: rzkhan on Mon, 25 July 2016
8 672 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 947 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 496 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 714 Fri, 22 July 2016 13:40
By: Solomon Yakobson
  GETTING NULLS WHEN USING PIVOT
By: vijay1255 on Thu, 21 July 2016
6 746 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 798 Thu, 21 July 2016 04:50
By: pcouas
  Extract value from xml
Oracle 12c
By: Raj12345 on Thu, 28 July 2016
3 464 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 541 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 769 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 721 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 524 Tue, 19 July 2016 07:31
By: saipavan.plsql
  Collection Last Record
Oracle 11g
By: ORAGENASHOK on Mon, 18 July 2016
4 590 Wed, 20 July 2016 03:05
By: cookiemonster
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: Sun Nov 19 06:29:38 CST 2017

Total time taken to generate the page: 0.08102 seconds