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 809 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 591 Sat, 30 July 2016 03:08
By: Michel Cadot
  how create synonym for full database
By: mfahimaamirgmailcom on Fri, 29 July 2016
7 502 Fri, 29 July 2016 07:54
By: BlackSwan
  Database vs Tablespace
By: KirkSpiritor on Wed, 27 July 2016
17 752 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 318 Thu, 28 July 2016 14:15
By: Bill B
  Extract value from xml
Oracle 12c
By: Raj12345 on Thu, 28 July 2016
3 316 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 320 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 1862 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 230 Thu, 28 July 2016 01:03
By: Michel Cadot
  XML tag selection
ORACLE 11g
By: lokimisc on Tue, 26 July 2016
8 550 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 321 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 778 Mon, 25 July 2016 15:00
By: Bill B
  LAG error
10g, 8i, win 8.1
By: rzkhan on Mon, 25 July 2016
8 444 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 349 Sun, 24 July 2016 14:55
By: Andrey_R
  Set a range into in time
Forms,
By: Salehin on Tue, 07 June 2016
32 1512 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 529 Fri, 22 July 2016 13:40
By: Solomon Yakobson
  GETTING NULLS WHEN USING PIVOT
By: vijay1255 on Thu, 21 July 2016
6 551 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 557 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 401 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 450 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 558 Thu, 21 July 2016 02:20
By: sss111ind
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
21 1907 Wed, 20 July 2016 07:19
By: SheliaWilson
  Collection Last Record
Oracle 11g
By: ORAGENASHOK on Mon, 18 July 2016
4 423 Wed, 20 July 2016 03:05
By: cookiemonster
  Merging BLOB
Oracle 11GR2, Windows Server 2008 R2
By: Jaffat1982 on Wed, 13 July 2016
6 559 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 375 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 1821 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 283 Mon, 18 July 2016 03:54
By: flyboy
  Table joining
Windows
By: 17111991 on Sun, 17 July 2016
4 448 Sun, 17 July 2016 23:44
By: Barbara Boehmer
  heirarchy between tables
By: 17111991 on Sun, 17 July 2016
1 205 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 326 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 901 Fri, 15 July 2016 14:45
By: Michel Cadot
  Parent child count?
By: P1Oracle on Tue, 12 July 2016
6 464 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 664 Tue, 12 July 2016 13:40
By: Bill B
  finding constrains on table
oracle 12c
By: gorants on Mon, 11 July 2016
15 627 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 397 Mon, 11 July 2016 17:52
By: Barbara Boehmer
  information
oracle 8
By: ceciaide on Fri, 08 July 2016
12 748 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 728 Sat, 09 July 2016 21:09
By: Barbara Boehmer
  Oracle reports
Oracle 11g
By: srinivas.k2005 on Mon, 04 July 2016
7 638 Tue, 05 July 2016 05:02
By: Michel Cadot
  query doubt
hp unix, oracle 10g
By: arun888 on Mon, 04 July 2016
4 457 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 660 Mon, 04 July 2016 17:20
By: Barbara Boehmer
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 Jan 18 06:19:51 CST 2017

Total time taken to generate the page: 0.14209 seconds