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 primary key ,foreign key , index and sequence associated to a table
By: gorants on Thu, 26 June 2014
2 412 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 442 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 694 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 1763 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 1173 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 457 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 444 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 729 Tue, 24 June 2014 09:48
By: Lalit Kumar B
  For all update clause
By: Devmunat on Tue, 24 June 2014
10 419 Tue, 24 June 2014 09:36
By: Lalit Kumar B
  XMLAGG Function
Oracle 11g
By: vicktorz on Tue, 24 June 2014
10 504 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 1997 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 297 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 274 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 1237 Tue, 24 June 2014 00:18
By: Michel Cadot
  Exchange partition from table at remote database
By: purnima1 on Thu, 19 June 2014
16 828 Tue, 24 June 2014 00:02
By: Lalit Kumar B
  convert char to date
Oracle 11g
By: mape on Sat, 21 June 2014
5 765 Mon, 23 June 2014 08:10
By: cookiemonster
  assertions
sql
By: ghostrider on Fri, 08 February 2013
13 1322 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 308 Mon, 23 June 2014 04:07
By: Lalit Kumar B
  Sys_refcursor
By: Rarawshenkiv on Thu, 20 February 2014
3 529 Mon, 23 June 2014 01:10
By: Barbara Boehmer
  sysdate functioning
Oracle DB 10g
By: aruntutor on Sun, 22 June 2014
5 541 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 367 Sun, 22 June 2014 04:59
By: dariyoosh
  Table Design Consideration
By: VIP2013 on Sat, 21 June 2014
17 746 Sat, 21 June 2014 15:29
By: VIP2013
  create sequence within pl/sql execute immediate.
By: laksha on Fri, 10 November 2006
4 12702 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 524 Sat, 21 June 2014 10:04
By: John Watson
  cursor is not working
By: aaditya321 on Sat, 21 June 2014
8 600 Sat, 21 June 2014 08:17
By: Michel Cadot
  doubt regarding exception handling?
11g
By: kiranrathodkr916 on Fri, 20 June 2014
15 662 Fri, 20 June 2014 15:33
By: Michel Cadot
  SYSDATE Central to Eastern time
Oracle 11gR2 11.2.0.4
By: kvignes1 on Fri, 20 June 2014
11 701 Fri, 20 June 2014 14:31
By: EdStevens
  Multibyte character
Oracle 11G
By: elaiyavel on Thu, 19 June 2014
11 716 Fri, 20 June 2014 09:06
By: Lalit Kumar B
  SQL or loops
Oracle 11g
By: rajivn786 on Wed, 18 June 2014
18 688 Thu, 19 June 2014 17:24
By: rajivn786
  ORA-01861: literal does not match format string
Oracle 11g
By: theladyd on Thu, 19 June 2014
4 423 Thu, 19 June 2014 13:21
By: BlackSwan
  ORA-01003: no statement parsed
By: sss111ind on Thu, 19 June 2014
5 366 Thu, 19 June 2014 08:59
By: sss111ind
  how to add mautiple partition on a table.
oracle 10g
By: jgjeetu on Thu, 19 June 2014
2 308 Thu, 19 June 2014 07:11
By: Lalit Kumar B
  Help required for Query
Oracle 11g
By: nickz on Tue, 10 June 2014
8 592 Thu, 19 June 2014 05:50
By: Michel Cadot
  How to add new partition on a table if Default partition is existing
oracle 10g
By: jgjeetu on Wed, 18 June 2014
5 396 Thu, 19 June 2014 05:48
By: Michel Cadot
  How to disable any command for user who has full rights
By: jgjeetu on Tue, 17 June 2014
5 402 Wed, 18 June 2014 08:23
By: Lalit Kumar B
  DBMS_JOB: Numerous jobs
DB 11.2.0.1.0, Windows server 2008 R2
By: ibergo on Thu, 15 May 2014
13 659 Wed, 18 June 2014 07:22
By: Michel Cadot
  How to print vertical numbers
By: aaditya321 on Wed, 18 June 2014
4 393 Wed, 18 June 2014 05:26
By: Michel Cadot
  create separate record for each column
Oracle 11g, Linux
By: rahul1982 on Tue, 17 June 2014
4 440 Wed, 18 June 2014 02:31
By: rahul1982
  Looping or SQL
Oracle 11g
By: rajivn786 on Tue, 17 June 2014
3 363 Tue, 17 June 2014 19:24
By: Solomon Yakobson
  Reqular expression
Oracle 11.2.0.3
By: pointers on Mon, 16 June 2014
9 568 Tue, 17 June 2014 10:44
By: Solomon Yakobson
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 Mar 05 06:37:01 CST 2015

Total time taken to generate the page: 0.13168 seconds