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
  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 2369 Tue, 06 January 2015 04:21
By: bgraupe
  Find a column Name using data
Oracle
By: hrdeepakkumar on Mon, 05 January 2015
6 2133 Tue, 06 January 2015 04:11
By: Lalit Kumar B
  Sql Querry based on condition
By: asbh123 on Wed, 10 December 2014
2 2507 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 354 Mon, 05 January 2015 14:21
By: EdStevens
  Update statement updates all rows
Oracle 7
By: rmccleave559 on Mon, 05 January 2015
14 314 Mon, 05 January 2015 09:38
By: cookiemonster
  String to Number conversion
Oracle 11G
By: sinpeak on Mon, 05 January 2015
3 783 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 950 Sat, 03 January 2015 13:18
By: manubatham20
  Check Time In Query
Oralce 10g
By: mamalik on Fri, 02 January 2015
13 1561 Sat, 03 January 2015 09:45
By: Kevin Meade
  Dynamic monthly sales report
By: ocpsujon on Sun, 28 December 2014
4 2108 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 2224 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 1730 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 3692 Wed, 31 December 2014 00:42
By: Littlefoot
  deadlock detected while waiting for resource
11g
By: cplusplus1 on Mon, 29 December 2014
4 1530 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 1793 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 2135 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 583 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 795 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 1122 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 4254 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 2360 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 655 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 3441 Sat, 27 December 2014 10:20
By: Solomon Yakobson
  ORA-01722: invalid number
Oracle 11g
By: Oracle_Walker on Wed, 24 December 2014
5 2093 Fri, 26 December 2014 13:37
By: Oracle_Walker
  Error in pl/sql Bubble sort code
By: jahanzaibniazi001 on Thu, 25 December 2014
3 2522 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 1281 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 3604 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 1180 Thu, 25 December 2014 05:27
By: Michel Cadot
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
5 2042 Wed, 24 December 2014 10:42
By: andrew again
  Complicate Query
Oracle SQL
By: raajes_n on Tue, 23 December 2014
13 1968 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 2437 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 2623 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 2623 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 3638 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 2310 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 3138 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 839 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 3322 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 3284 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2514 Sun, 21 December 2014 02:24
By: tamzidulamin
  Connect by Prior parent-child into string of values
10.2
By: lott42 on Fri, 07 February 2014
16 2647 Sun, 21 December 2014 01:32
By: Michel Cadot
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 06 12:07:29 CST 2015

Total time taken to generate the page: 0.28800 seconds