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
  How to find tables with nullable Unique Keys
Oracle 11.2.0.4
By: testoli on Wed, 07 January 2015
1 1275 Wed, 07 January 2015 04:47
By: Michel Cadot
  SYS_CONTEXT('USERENV','TERMINAL') gives "unknown" result in SQL Developer tool[split]
By: prejib on Mon, 05 January 2015
9 462 Tue, 06 January 2015 10:14
By: Michel Cadot
  Delete using a CTE
By: system243trd on Tue, 06 January 2015
6 713 Tue, 06 January 2015 07:21
By: Lalit Kumar B
  Sql querry needed for scenario
By: asbh123 on Tue, 06 January 2015
16 2419 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 2574 Tue, 06 January 2015 04:21
By: bgraupe
  Find a column Name using data
Oracle
By: hrdeepakkumar on Mon, 05 January 2015
6 2238 Tue, 06 January 2015 04:11
By: Lalit Kumar B
  Sql Querry based on condition
By: asbh123 on Wed, 10 December 2014
2 2574 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 435 Mon, 05 January 2015 14:21
By: EdStevens
  Update statement updates all rows
Oracle 7
By: rmccleave559 on Mon, 05 January 2015
14 383 Mon, 05 January 2015 09:38
By: cookiemonster
  String to Number conversion
Oracle 11G
By: sinpeak on Mon, 05 January 2015
3 881 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 1024 Sat, 03 January 2015 13:18
By: manubatham20
  Check Time In Query
Oralce 10g
By: mamalik on Fri, 02 January 2015
13 1645 Sat, 03 January 2015 09:45
By: Kevin Meade
  Dynamic monthly sales report
By: ocpsujon on Sun, 28 December 2014
4 2181 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 2458 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 1826 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 3924 Wed, 31 December 2014 00:42
By: Littlefoot
  deadlock detected while waiting for resource
11g
By: cplusplus1 on Mon, 29 December 2014
4 1780 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 1892 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 2377 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 651 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 952 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 1196 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 4452 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 2427 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 881 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 3522 Sat, 27 December 2014 10:20
By: Solomon Yakobson
  ORA-01722: invalid number
Oracle 11g
By: Oracle_Walker on Wed, 24 December 2014
5 2198 Fri, 26 December 2014 13:37
By: Oracle_Walker
  Error in pl/sql Bubble sort code
By: jahanzaibniazi001 on Thu, 25 December 2014
3 2608 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 1378 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 3677 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 1285 Thu, 25 December 2014 05:27
By: Michel Cadot
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
5 2170 Wed, 24 December 2014 10:42
By: andrew again
  Complicate Query
Oracle SQL
By: raajes_n on Tue, 23 December 2014
13 2044 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 2496 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 2690 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 2717 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 3688 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 2363 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 3220 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 910 Mon, 22 December 2014 12:39
By: orausern
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 May 28 01:26:08 CDT 2015

Total time taken to generate the page: 0.09551 seconds