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
  Sql querry needed for scenario
By: asbh123 on Tue, 06 January 2015
16 2328 Tue, 06 January 2015 05:56
By: Michel Cadot
  Check for missing records in 75 million records per day
Oracle 11g R2 (11.2.0.3.0), OS: Red Hat Enterprice Linux
By: bgraupe on Mon, 05 January 2015
20 2442 Tue, 06 January 2015 04:21
By: bgraupe
  Find a column Name using data
Oracle
By: hrdeepakkumar on Mon, 05 January 2015
6 2159 Tue, 06 January 2015 04:11
By: Lalit Kumar B
  Sql Querry based on condition
By: asbh123 on Wed, 10 December 2014
2 2530 Tue, 06 January 2015 03:03
By: asbh123
  Insert Query in between rows - SQL
Oracle 11g
By: rohit_shinez on Mon, 05 January 2015
20 369 Mon, 05 January 2015 14:21
By: EdStevens
  Update statement updates all rows
Oracle 7
By: rmccleave559 on Mon, 05 January 2015
14 329 Mon, 05 January 2015 09:38
By: cookiemonster
  String to Number conversion
Oracle 11G
By: sinpeak on Mon, 05 January 2015
3 818 Mon, 05 January 2015 07:11
By: Maaher
  Text based search
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 02 January 2015
14 967 Sat, 03 January 2015 13:18
By: manubatham20
  Check Time In Query
Oralce 10g
By: mamalik on Fri, 02 January 2015
13 1576 Sat, 03 January 2015 09:45
By: Kevin Meade
  Dynamic monthly sales report
By: ocpsujon on Sun, 28 December 2014
4 2120 Thu, 01 January 2015 13:53
By: Kevin Meade
  filling summary table from detail and updating the detail with summary reference
11.2.0.1.0
By: OraFerro on Mon, 29 December 2014
3 2310 Thu, 01 January 2015 13:18
By: Kevin Meade
  SQL*Net message from db link Doubt
Oracle 11gR2
By: tigsav on Wed, 31 December 2014
3 1756 Wed, 31 December 2014 08:08
By: Michel Cadot
  How to define Package Name in Reports Builder / REP-0069
Reports Builder
By: isteri143 on Mon, 29 December 2014
11 3715 Wed, 31 December 2014 00:42
By: Littlefoot
  deadlock detected while waiting for resource
11g
By: cplusplus1 on Mon, 29 December 2014
4 1618 Tue, 30 December 2014 11:00
By: Michel Cadot
  Update multiple rows based on duplication
11.2.0.1.0
By: OraFerro on Mon, 29 December 2014
6 1824 Tue, 30 December 2014 08:20
By: Lalit Kumar B
  How to select distinct sql_id together with clob column
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
3 2221 Tue, 30 December 2014 01:18
By: Michel Cadot
  Syntax for creating oracle type
Oracle 11g
By: Oracle_Walker on Mon, 29 December 2014
1 603 Mon, 29 December 2014 17:03
By: BlackSwan
  Problem with nested FOR Loop
Oracle 11.2.0.3.0 - Sun Solaris unix
By: welchaz on Mon, 29 December 2014
3 829 Mon, 29 December 2014 15:25
By: welchaz
  How to get list of top 15 sql order by by buffer gets
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
3 1143 Mon, 29 December 2014 08:49
By: BlackSwan
  LONG to VARCHAR2 conversion using dblink
Oracle Enterprise Edition : 10.2.0.5.0 - 64bit,HPUX: Version 10.2.0.5.0
By: Jay1 on Tue, 23 December 2014
12 4308 Mon, 29 December 2014 06:04
By: Jay1
  SQL query to calculate distance and update
Oracle 11.2.0.3
By: pointers on Tue, 23 December 2014
6 2371 Mon, 29 December 2014 04:10
By: pointers
  How to display a record from an array(nested table)
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Sun, 28 December 2014
6 740 Sun, 28 December 2014 17:16
By: buggleboy007
  When NOLOGGING will not be in effect
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 26 December 2014
12 3451 Sat, 27 December 2014 10:20
By: Solomon Yakobson
  ORA-01722: invalid number
Oracle 11g
By: Oracle_Walker on Wed, 24 December 2014
5 2116 Fri, 26 December 2014 13:37
By: Oracle_Walker
  Error in pl/sql Bubble sort code
By: jahanzaibniazi001 on Thu, 25 December 2014
3 2541 Fri, 26 December 2014 00:30
By: Michel Cadot
  Divide in Groups
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Wed, 24 December 2014
16 1302 Thu, 25 December 2014 12:51
By: manubatham20
  Comparing two TimeStamp columns giving unexpected result
Oracle 11G
By: Asfakul on Wed, 24 December 2014
5 3619 Thu, 25 December 2014 11:15
By: Michel Cadot
  PLS-00103: Encountered the symbol "END" when expecting one of
Oracle Database 11g XE 11.2.0.2.0 PL/SQL Release 11.2.0.2.0 OS WIN 7
By: weather3 on Wed, 24 December 2014
12 1218 Thu, 25 December 2014 05:27
By: Michel Cadot
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
5 2073 Wed, 24 December 2014 10:42
By: andrew again
  Complicate Query
Oracle SQL
By: raajes_n on Tue, 23 December 2014
13 1990 Wed, 24 December 2014 07:18
By: Michel Cadot
  How to write stored function to return column name?
By: mist598 on Wed, 24 December 2014
6 2445 Wed, 24 December 2014 05:14
By: Michel Cadot
  source does not have runnable target
sql developer, oracle 11g
By: zenthil86 on Tue, 23 December 2014
4 2636 Wed, 24 December 2014 01:38
By: Michel Cadot
  sql query for employees based on Org hierarchy
R12.1.3, 11g
By: afzaa2yahoocom on Tue, 23 December 2014
1 2655 Wed, 24 December 2014 01:36
By: Michel Cadot
  Dynamic PL/SQL which reads table and transposes rows to columns
oracle 11g R2, windows
By: zulu69 on Tue, 23 December 2014
3 3645 Wed, 24 December 2014 01:35
By: Michel Cadot
  Re:- how to check column value in particular format
windows7
By: ajamitjain129@gmail.com on Mon, 22 December 2014
4 2320 Tue, 23 December 2014 02:50
By: ajamitjain129@gmail.com
  Procedure to traverse the table based on fk constraints
oracle 11g sql developer
By: zenthil86 on Sat, 20 December 2014
12 3166 Mon, 22 December 2014 13:22
By: BlackSwan
  A question about using nested decode
Oracle 11.2.0.4 on Linux
By: orausern on Mon, 22 December 2014
5 860 Mon, 22 December 2014 12:39
By: orausern
  How to Delete Parent table record
Oracle 10g,11g
By: amitsukte on Tue, 10 July 2012
9 3369 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 3317 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2552 Sun, 21 December 2014 02:24
By: tamzidulamin
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: Fri Mar 27 16:52:02 CDT 2015

Total time taken to generate the page: 0.14648 seconds