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
  Help using regexp_substr - Urgent Help needed
Oracle 11
By: Member2014 on Thu, 04 August 2016
8 638 Fri, 05 August 2016 08:41
By: Member2014
  ORA-01917 ERROR
By: mfahimaamirgmailcom on Thu, 18 August 2016
2 504 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 979 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 436 Tue, 02 August 2016 07:51
By: John Watson
  SQL connectivity test
oracle, 11g, AIX
By: Prathikesh on Sat, 06 August 2016
24 777 Mon, 08 August 2016 02:50
By: cookiemonster
  Sorting
12c
By: ashlythomas on Sun, 31 July 2016
6 655 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 962 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 636 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 434 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 1003 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 482 Wed, 03 August 2016 13:37
By: Bill B
  Replace Accented Characters
By: ramya29p on Wed, 27 July 2016
21 785 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 403 Tue, 26 July 2016 10:35
By: John Watson
  XML tag selection
ORACLE 11g
By: lokimisc on Tue, 26 July 2016
8 845 Wed, 27 July 2016 02:09
By: pablolee
  LAG error
10g, 8i, win 8.1
By: rzkhan on Mon, 25 July 2016
8 617 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 681 Fri, 22 July 2016 13:40
By: Solomon Yakobson
  GETTING NULLS WHEN USING PIVOT
By: vijay1255 on Thu, 21 July 2016
6 697 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 724 Thu, 21 July 2016 04:50
By: pcouas
  Extract value from xml
Oracle 12c
By: Raj12345 on Thu, 28 July 2016
3 418 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 511 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 720 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 660 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 552 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 429 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 767 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 1058 Fri, 15 July 2016 14:45
By: Michel Cadot
  finding constrains on table
oracle 12c
By: gorants on Mon, 11 July 2016
15 765 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 499 Mon, 11 July 2016 17:52
By: Barbara Boehmer
  information
oracle 8
By: ceciaide on Fri, 08 July 2016
12 909 Mon, 11 July 2016 16:32
By: ceciaide
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: Sat Sep 23 02:23:30 CDT 2017

Total time taken to generate the page: 0.08005 seconds