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
  Need to put results of SQL into a table
Oracle SQL
By: skbytes on Fri, 21 February 2014
3 529 Fri, 21 February 2014 05:06
By: skbytes
  Oracle Partitioning
Oracle 10 G, Windows 7
By: s4.ora on Fri, 21 February 2014
3 374 Fri, 21 February 2014 03:22
By: Michel Cadot
  Multiple Output values in a dynamic sql
10.2.0.4, Windows
By: sandba00 on Thu, 20 February 2014
7 585 Fri, 21 February 2014 03:11
By: Michel Cadot
  Retrieve Data from a Table based on OR condition
Oracle 11G, Sun Solaris
By: ady_koolz on Tue, 11 February 2014
5 409 Fri, 21 February 2014 01:18
By: ady_koolz
  Timestamp gets truncated from cursor for loop
PL/SQL 11
By: DIPRINKS on Thu, 20 February 2014
2 450 Thu, 20 February 2014 11:42
By: DIPRINKS
  how to get previous row value?
By: pmreddy.mahi@gmail.com on Thu, 20 February 2014
26 1273 Thu, 20 February 2014 08:55
By: cookiemonster
  Future Partitions
Oracle 11g
By: srinivas.k2005 on Thu, 20 February 2014
2 306 Thu, 20 February 2014 08:23
By: srinivas.k2005
  alias name in where clause
By: anniepeteroracle on Thu, 20 February 2014
5 549 Thu, 20 February 2014 08:20
By: Michel Cadot
  no of counts from case when
By: ashwanth77 on Thu, 20 February 2014
3 532 Thu, 20 February 2014 06:18
By: Michel Cadot
  Procedure.,
By: Rarawshenkiv on Thu, 20 February 2014
5 489 Thu, 20 February 2014 05:56
By: Michel Cadot
  Terrifying result of sql-query, need explanation.
By: Cott on Tue, 18 February 2014
29 1336 Thu, 20 February 2014 03:03
By: Roachcoach
  Unique/check constraint on two columns
Oracle Database 11g Express Edition Release 11.2.0.2.0
By: kojot on Wed, 19 February 2014
7 626 Thu, 20 February 2014 00:25
By: kojot
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 387 Wed, 19 February 2014 13:29
By: John Watson
  Value multiplication help
Oracle 10g Pl/SQL
By: pmreddy.mahi@gmail.com on Wed, 19 February 2014
8 542 Wed, 19 February 2014 10:46
By: pmreddy.mahi@gmail.com
  Creating a table and referencing that table in same package.
Oracle 11g PL/SQL
By: skbytes on Wed, 19 February 2014
25 986 Wed, 19 February 2014 09:05
By: skbytes
  Exception while creating table using EXECUTE IMMEDIATE
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Wed, 19 February 2014
3 455 Wed, 19 February 2014 04:28
By: Manoj.Gupta.91
  get the data between the dates
win 7, oracle 11G
By: nischalinn on Tue, 18 February 2014
8 656 Wed, 19 February 2014 02:34
By: cookiemonster
  find latest ddl statement happened in table
11.2,AIX
By: shivshankar on Wed, 19 February 2014
3 335 Wed, 19 February 2014 00:53
By: Michel Cadot
  Struggling with DBMS_JOB.SUBMIT syntax
11g
By: bristolsmithy on Tue, 18 February 2014
3 510 Tue, 18 February 2014 15:15
By: bristolsmithy
  Oracle Pl/SQL Case Statement
PL/SQL 10.0
By: Uncle_Jake on Tue, 18 February 2014
1 370 Tue, 18 February 2014 13:37
By: Michel Cadot
  Query help
Oracle 11.2.0.3, Linux
By: sspn2010 on Tue, 18 February 2014
5 406 Tue, 18 February 2014 13:21
By: sspn2010
  Alter Table Command in relation to another table primary key
Oracle SQL Developer 4.0.0.13
By: Lahkra on Tue, 18 February 2014
11 558 Tue, 18 February 2014 11:07
By: BlackSwan
  First Character in "numeric-Alpha"
10.2.0
By: bluetooth420 on Mon, 10 February 2014
9 667 Tue, 18 February 2014 07:03
By: cookiemonster
  Oracle Compare 2 Tables
11g
By: developer12 on Tue, 18 February 2014
1 260 Tue, 18 February 2014 05:54
By: Michel Cadot
  not in, not exists query
By: mist598 on Mon, 17 February 2014
15 943 Tue, 18 February 2014 04:04
By: cookiemonster
  materialized view
oracle 10 g
By: oraclehi on Tue, 18 February 2014
5 382 Tue, 18 February 2014 03:23
By: Michel Cadot
  how to import table data from sql plus
oracle 10g
By: jgjeetu on Mon, 17 February 2014
26 1262 Tue, 18 February 2014 01:20
By: Littlefoot
  EMAIL from ORACLE8i using Corporate Netwrok
oracle 8i
By: na.vaithianathan on Sat, 15 February 2014
8 636 Mon, 17 February 2014 22:31
By: BlackSwan
  Query to get Status of Students as 'Pass' or 'Fail' Using Date Condition
Oracle 11g
By: sonudev on Wed, 12 February 2014
3 340 Mon, 17 February 2014 13:42
By: sonudev
  ORDER BY the day of the week
ORACLE DB SQL
By: hans_cellc on Mon, 17 February 2014
5 273 Mon, 17 February 2014 04:26
By: hans_cellc
  FLASHBACK QUERY
11g r2
By: mvrkr44 on Sun, 16 February 2014
7 598 Mon, 17 February 2014 03:41
By: John Watson
  SQL gets not result in Ora Enterprise 11.1.0.7.0 but in 10 and 11 XE it does
Ora Enterprise 11.1.0.7.0 on WinServer 2008 R2
By: geomac on Thu, 08 November 2012
9 655 Mon, 17 February 2014 03:41
By: geomac
  FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES
By: jgjeetu on Sun, 16 February 2014
10 735 Mon, 17 February 2014 01:28
By: Littlefoot
  What are valid and invalid functions in PL-SQL
Oracle
By: jgjeetu on Sat, 15 February 2014
2 351 Mon, 17 February 2014 00:18
By: msol25
  Convert number to CHAR
ORACLE DB SQL
By: hans_cellc on Sun, 16 February 2014
7 554 Sun, 16 February 2014 08:48
By: hans_cellc
  how to search the package object_type from all_objects
By: jgjeetu on Sat, 15 February 2014
3 553 Sat, 15 February 2014 05:51
By: jgjeetu
  how to check the details of any function or procedure etc
Oracle 10g
By: jgjeetu on Sat, 15 February 2014
5 408 Sat, 15 February 2014 05:49
By: jgjeetu
  SELECT query gives error
Oracle 11g R2
By: rchenna on Thu, 13 February 2014
13 833 Sat, 15 February 2014 02:12
By: Michel Cadot
  How to loop through a Date Range ?
Oracle 11g, Windows 7
By: tanthiamhuat on Fri, 14 February 2014
2 349 Fri, 14 February 2014 22:43
By: tanthiamhuat
  Calling PL/SQL function dynamically (with IN and OUT parameters
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: matspring1 on Wed, 12 February 2014
10 586 Fri, 14 February 2014 10:23
By: matspring1
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 Sep 14 21:39:05 CDT 2014

Total time taken to generate the page: 0.23589 seconds