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
  deferrable initially immediate
Oracle 10g,windows 7
By: thelearner on Fri, 01 November 2013
3 1871 Fri, 01 November 2013 15:30
By: John Watson
  onchange
By: nataliafoster26 on Fri, 01 November 2013
2 415 Fri, 01 November 2013 15:23
By: nataliafoster26
  Constraints in Describe
Oracle 10g,windows 7
By: thelearner on Fri, 01 November 2013
1 230 Fri, 01 November 2013 12:49
By: Littlefoot
  Loop in UTL_FILE is not getting closed
oracle 11.2.0.3.0 - Windows server 2008 R2
By: muktha_22 on Fri, 01 November 2013
1 375 Fri, 01 November 2013 01:58
By: Littlefoot
  CREATE New Table from existing tables
ORACLE 11g
By: arifugurel on Thu, 31 October 2013
7 418 Fri, 01 November 2013 01:20
By: Littlefoot
  select * from one table but not all tables in a query
Oracle 11g
By: seahaze on Wed, 30 October 2013
14 776 Thu, 31 October 2013 15:16
By: John Watson
  LONG data type obsolete - but Oracle use them in meta data (directory)? WTF?
Oracle 10g
By: rc3d on Thu, 31 October 2013
4 530 Thu, 31 October 2013 15:08
By: John Watson
  PL/SQL
SQL DEVELOPER
By: aravindreddy.akiti on Thu, 31 October 2013
3 444 Thu, 31 October 2013 14:25
By: Lalit Kumar B
  XML Variables
10g r2
By: leeweb on Thu, 31 October 2013
2 245 Thu, 31 October 2013 10:32
By: Solomon Yakobson
  Pivot query: grouping pivot field, using query for IN clause
Oracle 11.2.0.1.0
By: OraFerro on Thu, 31 October 2013
4 534 Thu, 31 October 2013 07:06
By: flyboy
  string to date
Oracle 11g
By: oracle_doubt on Thu, 31 October 2013
7 503 Thu, 31 October 2013 05:38
By: Solomon Yakobson
  convert local time to UTC
oracle Database 11g Enterprise Edition Release 11.1.0.6.0
By: rkhatiwala on Wed, 30 October 2013
7 620 Wed, 30 October 2013 18:22
By: cookiemonster
  Meaning of the piece of code
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production,TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
By: gupta27 on Wed, 30 October 2013
6 371 Wed, 30 October 2013 16:01
By: Lalit Kumar B
  Can we have 2 insert statements for 1 for loop
Oracle 10g Forms, WinXP
By: stalin4d on Wed, 30 October 2013
9 725 Wed, 30 October 2013 09:38
By: Michel Cadot
  Troubleshoot procedure error
Oracle 11g
By: Santhosh05 on Wed, 23 October 2013
27 1344 Wed, 30 October 2013 07:44
By: cookiemonster
  update with case using select
11.2.0.3.0
By: lijok on Wed, 30 October 2013
3 228 Wed, 30 October 2013 05:43
By: lijok
  Pagination Query
By: rameshaimhigh@gmail.com on Wed, 30 October 2013
1 230 Wed, 30 October 2013 02:48
By: Michel Cadot
  getting total and single name in one query
Oracle 10g
By: sss111ind on Tue, 29 October 2013
5 498 Tue, 29 October 2013 10:25
By: sss111ind
  Concatenating address fields
Oracle 10g
By: sss111ind on Mon, 28 October 2013
17 786 Tue, 29 October 2013 04:49
By: sss111ind
  Separate string based on Comma (merged 2)
Oracle 10g
By: sss111ind on Mon, 28 October 2013
10 546 Tue, 29 October 2013 03:58
By: sss111ind
  why it doesnt save in table
By: nataliafoster26 on Mon, 28 October 2013
6 439 Tue, 29 October 2013 02:27
By: Littlefoot
  Query for the below requirement
10.2.0.5
By: avineshr on Mon, 28 October 2013
4 439 Tue, 29 October 2013 01:17
By: Michel Cadot
  sql
By: walls on Mon, 28 October 2013
1 259 Mon, 28 October 2013 14:04
By: Littlefoot
  External Tables
UNIX, Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
By: ind9 on Mon, 28 October 2013
1 466 Mon, 28 October 2013 11:52
By: Solomon Yakobson
  XMLTYPE datatypw
Oracle 10g
By: ashish_sun123 on Mon, 28 October 2013
5 392 Mon, 28 October 2013 11:41
By: _jum
  ad hoc MINUS - compare values in SQL code to values in table
Oracle 10g
By: rc3d on Mon, 28 October 2013
6 438 Mon, 28 October 2013 09:57
By: rc3d
  SQL IN FUNCTION
ORACLE 10G
By: annu-agi on Mon, 28 October 2013
3 347 Mon, 28 October 2013 06:00
By: annu-agi
  How to get department wise effective rate
By: lavkumar78 on Sat, 26 October 2013
3 415 Sun, 27 October 2013 05:39
By: Solomon Yakobson
  EMP and DEPT Tables
By: cooler2005 on Mon, 04 December 2006
25 6588 Sun, 27 October 2013 02:47
By: Michel Cadot
  Getting Hostname,systimestamp over db link
By: sekharsomu on Sat, 26 October 2013
8 627 Sat, 26 October 2013 16:20
By: Solomon Yakobson
  plsql
oracle 10 g , Windows7
By: saturnel on Sat, 26 October 2013
3 337 Sat, 26 October 2013 09:39
By: saturnel
  Another dynamic sql using dbms_sql.execute
11.2
By: lott42 on Wed, 23 October 2013
14 645 Fri, 25 October 2013 18:40
By: BlackSwan
  PLS-00402: alias required in SELECT list of cursor to avoid duplicate column
Oracle 11G
By: kumsenthil on Fri, 25 October 2013
6 430 Fri, 25 October 2013 15:40
By: kumsenthil
  recurrsion
oracle 9.2
By: nitinbane on Fri, 25 October 2013
7 452 Fri, 25 October 2013 09:19
By: Solomon Yakobson
  UNDER ANY TABLE / TYPE / VIEW
Oracle 11.2.0.3
By: gazzag on Thu, 24 October 2013
6 458 Fri, 25 October 2013 02:59
By: gazzag
  [SOLVED] Aliases, a lesson learnt
11.2.0.3.0
By: Maaher on Fri, 25 October 2013
0 333 Fri, 25 October 2013 01:51
By: Maaher
  get number of seconds between two DATE (min and max) and calculate trans/sec
Oracle 10g
By: rc3d on Wed, 23 October 2013
18 1063 Fri, 25 October 2013 00:36
By: Maaher
  Oracle Stored Procedure to Load Flat File Data
11g
By: developer12 on Thu, 24 October 2013
12 597 Thu, 24 October 2013 09:48
By: Michel Cadot
  Unique null and multiple non-null
11.2.0.3
By: Amine on Thu, 24 October 2013
2 238 Thu, 24 October 2013 09:29
By: Amine
  date format problem
oracle 11g
By: rhnilu on Thu, 24 October 2013
2 327 Thu, 24 October 2013 02:50
By: flyboy
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 Apr 18 07:01:48 CDT 2014

Total time taken to generate the page: 0.05733 seconds