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
  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 2798 Wed, 28 September 2016 06:15
By: Xandot
  query doubt
hp unix, oracle 10g
By: arun888 on Mon, 04 July 2016
4 585 Tue, 05 July 2016 00:43
By: arun888
  Procidure includ not duplicate
By: rkled on Mon, 04 July 2016
3 444 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 428 Mon, 04 July 2016 10:13
By: jeeva7311
  PL/SQL error
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
By: jcasas on Sat, 09 July 2016
11 855 Sat, 09 July 2016 21:09
By: Barbara Boehmer
  SQL problem - variation on top-n-of-group. DDL and DML supplied.
Oracle - any version this millenium, also MySQL and PostgreSQL.
By: dragam on Sat, 02 July 2016
5 869 Mon, 04 July 2016 17:20
By: Barbara Boehmer
  PLSQL grant script not working correctly
12c
By: ICB555 on Fri, 01 July 2016
5 716 Mon, 04 July 2016 02:56
By: cookiemonster
  PLS-00907: cannot load libraryunit PROD.DAILY_RPT (referenced by )
11G
By: venkat111 on Fri, 01 July 2016
6 1303 Tue, 12 July 2016 13:40
By: Bill B
  How to display report format data
Oracle 11 ( 1 2)
By: ssyr22 on Thu, 30 June 2016
49 2035 Thu, 28 July 2016 02:40
By: Barbara Boehmer
  String Manipulations
Oracle 11g R2
By: javed.khan on Mon, 04 July 2016
1 415 Mon, 04 July 2016 13:36
By: Michel Cadot
  How can I modify length of a column in type definition.
11.2.0.1.0
By: Manoj.Gupta.91 on Thu, 30 June 2016
2 490 Thu, 30 June 2016 16:24
By: Barbara Boehmer
icon5.gif Conversion Approach
Oracle 12c, Windows Server 2012
By: abacusdotcom on Tue, 28 June 2016
4 579 Wed, 29 June 2016 07:38
By: abacusdotcom
  transposing of data in oracle
oracle 12 c
By: tolupuluri on Tue, 28 June 2016
23 2090 Tue, 19 July 2016 03:49
By: Michel Cadot
  Pick One : A Query for Multiple Submission of form but to take only first one.
Oracle 11g R2
By: javed.khan on Tue, 28 June 2016
11 694 Mon, 04 July 2016 13:13
By: Michel Cadot
  Issue in Exxternal Table
Oracle 11g
By: jeeva7311 on Tue, 28 June 2016
9 657 Thu, 30 June 2016 08:51
By: Solomon Yakobson
  Count group data
12.1.0.2
By: bdtran on Sat, 02 July 2016
21 2025 Wed, 03 August 2016 23:44
By: bdtran
  column with data_type CLOB does not appear in user_ind_columns, why?
By: gunderj on Sat, 25 June 2016
7 619 Sat, 25 June 2016 10:57
By: Michel Cadot
  How to prevent trigger from firing on failed insert
Oracle 8,2
By: laddg on Fri, 24 June 2016
13 792 Sat, 25 June 2016 07:02
By: EdStevens
  Help Creating a Trigger for Reoccuring Events
Oracle 12c
By: mattfriend on Thu, 23 June 2016
12 931 Mon, 27 June 2016 09:22
By: Bill B
  Analytic Report query
Oracle 11g
By: srinivas.k2005 on Thu, 23 June 2016
2 488 Thu, 23 June 2016 08:18
By: srinivas.k2005
icon4.gif Table update through nested loop issue in function
By: nitesh.erp@gmail.com on Thu, 23 June 2016
15 621 Thu, 23 June 2016 09:28
By: nitesh.erp@gmail.com
  Better query
Oracle 11
By: iliyan_84@abv.bg on Wed, 22 June 2016
2 497 Thu, 23 June 2016 02:56
By: Roachcoach
  SQL for Tables
Oracle 11g R2
By: javed.khan on Mon, 27 June 2016
15 749 Mon, 27 June 2016 21:11
By: BlackSwan
  how to get one week historical query for v$SQL
By: royalyogi on Tue, 21 June 2016
4 500 Wed, 22 June 2016 06:34
By: EdStevens
  low performance of CONNECT BY
Oracle 11g
By: Elham_gh on Tue, 28 June 2016
2 512 Tue, 28 June 2016 08:56
By: Bill B
  A Query for Seating Arrangement
By: javed.khan on Tue, 21 June 2016
5 3317 Wed, 22 June 2016 00:43
By: Michel Cadot
  SQL to filter redundant key field
Oracle 9.2 on Solaris
By: raghx on Mon, 20 June 2016
2 406 Mon, 20 June 2016 19:34
By: Barbara Boehmer
  Aggregate based on serial number after checking for thresholds
By: ketangarg86 on Mon, 20 June 2016
3 368 Mon, 20 June 2016 13:06
By: Michel Cadot
  how to export the data from table to the file
oracle 11g
By: tolupuluri on Mon, 20 June 2016
4 450 Mon, 20 June 2016 15:31
By: tolupuluri
  Exception Handling
oracle 11g
By: Satheesh.A on Mon, 20 June 2016
4 518 Mon, 20 June 2016 03:01
By: cookiemonster
  LAG function
10g, win8.1
By: rzkhan on Sat, 18 June 2016
3 553 Sat, 18 June 2016 02:30
By: Michel Cadot
  connect and level
sql developer
By: nath123 on Fri, 17 June 2016
1 443 Fri, 17 June 2016 15:10
By: Solomon Yakobson
  Query table with multi part column names
11g
By: bobghw on Thu, 16 June 2016
6 487 Thu, 16 June 2016 15:21
By: Bill B
  Calculating values from two different tables by using SQL command.
Oracle 11g ver 11.2.0.1.0
By: faisal78 on Thu, 16 June 2016
5 492 Thu, 16 June 2016 08:39
By: Bill B
  TO_NUMBER function not working
By: richard_oak on Wed, 15 June 2016
2 512 Wed, 15 June 2016 17:56
By: richard_oak
  What is wrong with this sql code?
By: anticristo on Tue, 14 June 2016
3 633 Wed, 15 June 2016 07:34
By: EdStevens
  regexp replace
Oracle 11g, Win 7
By: rajivn786 on Tue, 14 June 2016
9 605 Tue, 14 June 2016 15:55
By: Bill B
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: Thu Sep 21 05:32:24 CDT 2017

Total time taken to generate the page: 0.03038 seconds