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
  Find unique and sorted field value
By: amarbose on Tue, 16 August 2016
10 552 Wed, 17 August 2016 06:28
By: Michel Cadot
  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 668 Wed, 17 August 2016 04:20
By: Michel Cadot
  keep only numeric values in a string
oracle 11g, windows
By: chinmay45 on Tue, 16 August 2016
18 542 Wed, 17 August 2016 01:35
By: Michel Cadot
  PLS-00231:
By: desmond30 on Mon, 15 August 2016
7 509 Tue, 16 August 2016 08:08
By: Michel Cadot
  Update or create function paramater
Oracle Database 10g Enterprise Edition ,10.2.0.4.0, linux64_86
By: abdo2203 on Sat, 13 August 2016
5 559 Sat, 13 August 2016 09:36
By: abdo2203
  Help reverse engineering pl sql query
Oracle sql
By: jprisk on Fri, 12 August 2016
4 545 Fri, 12 August 2016 15:03
By: Barbara Boehmer
  Repeat data based on count column
Oracle 11g Release 2, Linux
By: anil_mk on Thu, 11 August 2016
5 413 Fri, 12 August 2016 07:23
By: anil_mk
  Dynamic Update statement Error
Oracle 9i
By: cvs_1984 on Thu, 11 August 2016
2 315 Thu, 11 August 2016 05:31
By: cvs_1984
  Query help
Oracle 12.1.0.2.0, Linux
By: sspn2010 on Mon, 08 August 2016
6 534 Tue, 09 August 2016 16:21
By: sspn2010
  Check if value EXISTS in plsql table of record type
11G
By: harshadsp on Wed, 03 August 2016
11 773 Mon, 08 August 2016 05:57
By: harshadsp
  SQL connectivity test
oracle, 11g, AIX
By: Prathikesh on Sat, 06 August 2016
24 660 Mon, 08 August 2016 02:50
By: cookiemonster
  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 1138 Sat, 06 August 2016 10:38
By: Michel Cadot
  Sum from part of coloumn
Oracle,11g Release 11.2.0.4.0, Solaris 11
By: nms123 on Fri, 05 August 2016
2 369 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 534 Fri, 05 August 2016 08:41
By: Member2014
  Regular expression search
By: saipradyumn on Fri, 05 August 2016
2 312 Fri, 05 August 2016 07:58
By: Solomon Yakobson
  Count group data
12.1.0.2
By: bdtran on Sat, 02 July 2016
21 1886 Wed, 03 August 2016 23:44
By: bdtran
  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 408 Wed, 03 August 2016 13:37
By: Bill B
  Replace Accented Characters
By: ramya29p on Wed, 27 July 2016
21 679 Wed, 03 August 2016 05:12
By: Michel Cadot
  Execution of Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 02 August 2016
4 355 Tue, 02 August 2016 07:51
By: John Watson
  how to report oracle internal error
By: desmond30 on Wed, 27 July 2016
4 781 Tue, 02 August 2016 00:24
By: Michel Cadot
  Sorting
12c
By: ashlythomas on Sun, 31 July 2016
6 555 Mon, 01 August 2016 08:05
By: pablolee
icon5.gif Error An INTO Clause
Oracle, Toad, SQL Developer, Windows Server
By: abacusdotcom on Tue, 26 July 2016
6 598 Mon, 01 August 2016 06:53
By: EdStevens
  Same record with Space and Without Space
Oracle 12c, Windows NT
By: pstanand on Fri, 29 July 2016
13 856 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 647 Sat, 30 July 2016 03:08
By: Michel Cadot
  how create synonym for full database
By: mfahimaamirgmailcom on Fri, 29 July 2016
7 536 Fri, 29 July 2016 07:54
By: BlackSwan
  Database vs Tablespace
By: KirkSpiritor on Wed, 27 July 2016
17 789 Fri, 29 July 2016 07:42
By: EdStevens
  Creating different worksheets in a single excel
Oracle 11g
By: venkat111 on Thu, 28 July 2016
2 349 Thu, 28 July 2016 14:15
By: Bill B
  Extract value from xml
Oracle 12c
By: Raj12345 on Thu, 28 July 2016
3 342 Thu, 28 July 2016 14:12
By: Bill B
  place set values next to each other
Oracle 11.2.0.3
By: pointers on Thu, 28 July 2016
4 349 Thu, 28 July 2016 13:47
By: BlackSwan
  How to display report format data
Oracle 11 ( 1 2)
By: ssyr22 on Thu, 30 June 2016
49 1903 Thu, 28 July 2016 02:40
By: Barbara Boehmer
  unusable index on inserting data into partition table
Oracle 11.0.2
By: jbvenkat_mcq on Thu, 28 July 2016
3 248 Thu, 28 July 2016 01:03
By: Michel Cadot
  XML tag selection
ORACLE 11g
By: lokimisc on Tue, 26 July 2016
8 614 Wed, 27 July 2016 02:09
By: pablolee
  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 347 Tue, 26 July 2016 10:35
By: John Watson
  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 805 Mon, 25 July 2016 15:00
By: Bill B
  LAG error
10g, 8i, win 8.1
By: rzkhan on Mon, 25 July 2016
8 497 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 376 Sun, 24 July 2016 14:55
By: Andrey_R
  Set a range into in time
Forms,
By: Salehin on Tue, 07 June 2016
32 1571 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 573 Fri, 22 July 2016 13:40
By: Solomon Yakobson
  GETTING NULLS WHEN USING PIVOT
By: vijay1255 on Thu, 21 July 2016
6 591 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 599 Thu, 21 July 2016 12:20
By: Solomon Yakobson
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 Mar 29 21:46:47 CDT 2017

Total time taken to generate the page: 0.21511 seconds