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
  Another Hierarchical circular reference question
10.2
By: lott42 on Thu, 03 July 2014
7 288 Thu, 03 July 2014 12:33
By: lott42
  Add sentence if result of string concatenation is too long
Toad for Oracle, v11.6.1.6, Windows 7
By: a415 on Fri, 27 June 2014
8 622 Thu, 03 July 2014 11:20
By: LKBrwn_DBA
  Killing job after sometime is not working.
Oracle 11g
By: ramya_162 on Wed, 02 July 2014
6 509 Wed, 02 July 2014 05:03
By: John Watson
  PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
Oracle 11g, 11.2.0.2.0, Windows 7.
By: ho2512 on Wed, 02 July 2014
8 623 Wed, 02 July 2014 04:53
By: ho2512
  Grouped data on detail record
10g
By: RM33 on Tue, 01 July 2014
3 356 Wed, 02 July 2014 01:47
By: John Watson
  DBMS_LOB defined in a View - Error: ORA-01031: insufficient privileges
Oracle 11g
By: sivakumar121 on Tue, 01 July 2014
1 267 Tue, 01 July 2014 04:47
By: Michel Cadot
  CURSOR FOR LOOP
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 27 June 2014
4 491 Mon, 30 June 2014 21:46
By: manubatham20
  Data extract from scheduled process improvement
By: ramraju20000 on Sun, 29 June 2014
5 437 Mon, 30 June 2014 15:33
By: Bill B
  Display output like.
By: vik@s on Tue, 24 June 2014
12 700 Mon, 30 June 2014 15:28
By: Bill B
  >= date field in Oracle not retrieving expected results (merged 2 by MC)
Oracle Database 10g Release 10.2.0.3.0 - Production
By: ipisors on Mon, 30 June 2014
3 358 Mon, 30 June 2014 11:42
By: ipisors
  SELECT grant on view to a role.
Oracle 11G
By: sinpeak on Mon, 30 June 2014
4 345 Mon, 30 June 2014 06:38
By: Solomon Yakobson
  Sort data output to excel (owa_util) from 2 cursor
By: aryanna on Wed, 05 March 2014
2 507 Fri, 27 June 2014 18:03
By: Barbara Boehmer
  input argument in function use in select statement
By: Anjas_DA on Fri, 27 June 2014
10 423 Fri, 27 June 2014 12:32
By: flyboy
  find all the null data value in column
oracle 11gr2
By: guddu_12 on Fri, 27 June 2014
4 358 Fri, 27 June 2014 07:38
By: guddu_12
  SQL query to use Reg_exp
Oracle 10g/11g
By: dorerajp on Thu, 26 June 2014
12 486 Fri, 27 June 2014 07:12
By: Solomon Yakobson
  How to enforce key uniqueness in a temporal table?
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: SeanBDurkin on Wed, 25 June 2014
8 486 Thu, 26 June 2014 16:13
By: DrabJay
  How to find primary key ,foreign key , index and sequence associated to a table
By: gorants on Thu, 26 June 2014
2 354 Thu, 26 June 2014 11:42
By: BlackSwan
  Incorrect number of seconds returned from function
Oracle 11g R2
By: PeterS on Wed, 25 June 2014
6 373 Thu, 26 June 2014 04:54
By: Solomon Yakobson
  Oracle function/package same as SAS spedis function
Oracle 11g, Linux
By: rahul1982 on Thu, 26 June 2014
4 536 Thu, 26 June 2014 03:02
By: pablolee
  ORA-00060: deadlock detected while waiting for resource
ORACLE 11g
By: gorants on Mon, 23 June 2014
33 1039 Wed, 25 June 2014 22:31
By: rleishman
  utl_http how to close the request?
Oracle 11g
By: tjagiello on Wed, 25 June 2014
4 828 Wed, 25 June 2014 08:51
By: Michel Cadot
  SQL script to find ACTIVE and INACTIVE CPU on HP-UX server
Oracle 10.2.0.3 - HP-UX IA (64-bit)
By: hitesh.bhatt on Wed, 25 June 2014
5 409 Wed, 25 June 2014 08:12
By: Lalit Kumar B
  Database design for email messaging system
Windows
By: ramraju20000 on Tue, 24 June 2014
4 405 Tue, 24 June 2014 13:15
By: Michel Cadot
  ERROR: ORA-04063: package body "SYSTEM.MONITOR_SPACE" has errors
10.2.0.5
By: Ora_sh_user on Tue, 24 June 2014
6 586 Tue, 24 June 2014 09:48
By: Lalit Kumar B
  For all update clause
By: Devmunat on Tue, 24 June 2014
10 397 Tue, 24 June 2014 09:36
By: Lalit Kumar B
  XMLAGG Function
Oracle 11g
By: vicktorz on Tue, 24 June 2014
10 424 Tue, 24 June 2014 05:05
By: Lalit Kumar B
  Arabic letters not displayed in xmltype table
11G ( 1 2)
By: ledo60 on Sun, 01 June 2014
62 1899 Tue, 24 June 2014 04:29
By: cookiemonster
  date format as dd/mm/yyyy in the excel
By: mist598 on Tue, 24 June 2014
3 268 Tue, 24 June 2014 03:59
By: Lalit Kumar B
  can we use 'Select' in IF statement
By: vicktorz on Tue, 24 June 2014
2 260 Tue, 24 June 2014 03:52
By: Michel Cadot
  Help Required in SQL Analytic Function.
Oracle 11gR2, 11.2.0.1.0, RHEL 5.0
By: jimit_shaili on Sat, 14 June 2014
26 1186 Tue, 24 June 2014 00:18
By: Michel Cadot
  Exchange partition from table at remote database
By: purnima1 on Thu, 19 June 2014
16 746 Tue, 24 June 2014 00:02
By: Lalit Kumar B
  convert char to date
Oracle 11g
By: mape on Sat, 21 June 2014
5 694 Mon, 23 June 2014 08:10
By: cookiemonster
  assertions
sql
By: ghostrider on Fri, 08 February 2013
13 1249 Mon, 23 June 2014 07:11
By: John Watson
  Procedure to read mails from mailbox and insert into table
oracle 11.2.0.1.0 windows XP
By: kavirajd on Mon, 23 June 2014
2 290 Mon, 23 June 2014 04:07
By: Lalit Kumar B
  Sys_refcursor
By: Rarawshenkiv on Thu, 20 February 2014
3 501 Mon, 23 June 2014 01:10
By: Barbara Boehmer
  sysdate functioning
Oracle DB 10g
By: aruntutor on Sun, 22 June 2014
5 485 Sun, 22 June 2014 12:49
By: Lalit Kumar B
  Getting duplicate entry in audit table after triggered
Oracle DB 10g
By: aruntutor on Sun, 22 June 2014
4 345 Sun, 22 June 2014 04:59
By: dariyoosh
  Table Design Consideration
By: VIP2013 on Sat, 21 June 2014
17 690 Sat, 21 June 2014 15:29
By: VIP2013
  create sequence within pl/sql execute immediate.
By: laksha on Fri, 10 November 2006
4 12542 Sat, 21 June 2014 12:23
By: Lalit Kumar B
  PARALLEL hint is not working in 11g.
By: M. Salman Sabir on Fri, 20 June 2014
4 478 Sat, 21 June 2014 10:04
By: John Watson
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: Mon Dec 22 00:37:55 CST 2014

Total time taken to generate the page: 0.09005 seconds