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 query for a project scheduler
11.2.0.3
By: Amine on Fri, 09 January 2015
21 4062 Wed, 14 January 2015 13:25
By: Amine
  Handle duplicate Configurations (merged)
By: jg5111 on Mon, 12 January 2015
21 1672 Wed, 14 January 2015 05:14
By: Lalit Kumar B
  rownum query
Oracle 10g
By: sss111ind on Wed, 14 January 2015
10 1129 Wed, 14 January 2015 02:22
By: sss111ind
  Table Access Full
Oracle 9i
By: fairdaus on Tue, 13 January 2015
3 709 Tue, 13 January 2015 07:55
By: BlackSwan
  Rollback in DBMS_PARALLEL_EXECUTE
ORACLE 11G
By: aravind.peddola@gmail.com on Tue, 13 January 2015
1 625 Tue, 13 January 2015 02:47
By: Michel Cadot
  convert comma separated string to IN clause
Oracle version 11g R2
By: robh0502 on Mon, 12 January 2015
5 432 Mon, 12 January 2015 14:22
By: Solomon Yakobson
  LOB
By: manishdba007 on Sun, 11 January 2015
3 1103 Sun, 11 January 2015 12:15
By: Michel Cadot
  How to count working day
By: aaditya321 on Wed, 03 September 2014
17 2537 Sat, 10 January 2015 09:17
By: Lalit Kumar B
  how to run PLSQL procedure in foreground in SQL command prompt
By: victoryhendry on Fri, 09 January 2015
17 1714 Sat, 10 January 2015 08:20
By: BlackSwan
  How to find Nth weekday from current date?
Oracle 11g
By: Oracle_Walker on Thu, 08 January 2015
8 3196 Sat, 10 January 2015 00:30
By: Michel Cadot
  Generate flat file size more than 32767
oracle 11g
By: gbpatelin on Fri, 09 January 2015
1 412 Fri, 09 January 2015 17:35
By: BlackSwan
  Table design help
By: gorants on Fri, 09 January 2015
12 932 Fri, 09 January 2015 14:51
By: gorants
  calling proc with packag giving no output
By: mist598 on Thu, 08 January 2015
5 2031 Fri, 09 January 2015 01:48
By: flyboy
  how to loop and duplicate a string
11G
By: kmmchan on Thu, 08 January 2015
2 2036 Fri, 09 January 2015 00:37
By: Michel Cadot
  different outputs on same parameter (datatype date) while using 'like' and '='
oracle 10g
By: jgjeetu on Thu, 08 January 2015
11 1281 Thu, 08 January 2015 09:42
By: Solomon Yakobson
  Need to get only decimal values upto 2 digits if we have nothing in decimal points that has to be 0
oracle 11g R2
By: suramsmanu on Sun, 04 January 2015
6 2185 Thu, 08 January 2015 02:37
By: Lalit Kumar B
  creation of view by passing the values dynamically
11.2.0.1
By: grpatwari on Wed, 07 January 2015
10 3195 Thu, 08 January 2015 00:58
By: grpatwari
  How to find tables with nullable Unique Keys
Oracle 11.2.0.4
By: testoli on Wed, 07 January 2015
1 1330 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 643 Tue, 06 January 2015 10:14
By: Michel Cadot
  Delete using a CTE
By: system243trd on Tue, 06 January 2015
6 831 Tue, 06 January 2015 07:21
By: Lalit Kumar B
  Sql querry needed for scenario
By: asbh123 on Tue, 06 January 2015
16 2618 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 2843 Tue, 06 January 2015 04:21
By: bgraupe
  Find a column Name using data
Oracle
By: hrdeepakkumar on Mon, 05 January 2015
6 2326 Tue, 06 January 2015 04:11
By: Lalit Kumar B
  Sql Querry based on condition
By: asbh123 on Wed, 10 December 2014
2 2652 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 507 Mon, 05 January 2015 14:21
By: EdStevens
  Update statement updates all rows
Oracle 7
By: rmccleave559 on Mon, 05 January 2015
14 445 Mon, 05 January 2015 09:38
By: cookiemonster
  String to Number conversion
Oracle 11G
By: sinpeak on Mon, 05 January 2015
3 973 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 1078 Sat, 03 January 2015 13:18
By: manubatham20
  Check Time In Query
Oralce 10g
By: mamalik on Fri, 02 January 2015
13 1726 Sat, 03 January 2015 09:45
By: Kevin Meade
  Dynamic monthly sales report
By: ocpsujon on Sun, 28 December 2014
4 2245 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 2562 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 1884 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 4067 Wed, 31 December 2014 00:42
By: Littlefoot
  deadlock detected while waiting for resource
11g
By: cplusplus1 on Mon, 29 December 2014
4 1890 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 1954 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 2508 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 696 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 1017 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 1245 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 4732 Mon, 29 December 2014 06:04
By: Jay1
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: Sun Aug 30 17:34:51 CDT 2015

Total time taken to generate the page: 0.12377 seconds