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
  Future Partitions
Oracle 11g
By: srinivas.k2005 on Thu, 20 February 2014
2 310 Thu, 20 February 2014 08:23
By: srinivas.k2005
  alias name in where clause
By: anniepeteroracle on Thu, 20 February 2014
5 558 Thu, 20 February 2014 08:20
By: Michel Cadot
  no of counts from case when
By: ashwanth77 on Thu, 20 February 2014
3 538 Thu, 20 February 2014 06:18
By: Michel Cadot
  Procedure.,
By: Rarawshenkiv on Thu, 20 February 2014
5 495 Thu, 20 February 2014 05:56
By: Michel Cadot
  Terrifying result of sql-query, need explanation.
By: Cott on Tue, 18 February 2014
29 1346 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 633 Thu, 20 February 2014 00:25
By: kojot
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 399 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 550 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 992 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 461 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 663 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 342 Wed, 19 February 2014 00:53
By: Michel Cadot
  Struggling with DBMS_JOB.SUBMIT syntax
11g
By: bristolsmithy on Tue, 18 February 2014
3 517 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 378 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 410 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 563 Tue, 18 February 2014 11:07
By: BlackSwan
  First Character in "numeric-Alpha"
10.2.0
By: bluetooth420 on Mon, 10 February 2014
9 674 Tue, 18 February 2014 07:03
By: cookiemonster
  Oracle Compare 2 Tables
11g
By: developer12 on Tue, 18 February 2014
1 263 Tue, 18 February 2014 05:54
By: Michel Cadot
  not in, not exists query
By: mist598 on Mon, 17 February 2014
15 952 Tue, 18 February 2014 04:04
By: cookiemonster
  materialized view
oracle 10 g
By: oraclehi on Tue, 18 February 2014
5 388 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 1275 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 639 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 343 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 275 Mon, 17 February 2014 04:26
By: hans_cellc
  FLASHBACK QUERY
11g r2
By: mvrkr44 on Sun, 16 February 2014
7 605 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 660 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 741 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 352 Mon, 17 February 2014 00:18
By: msol25
  Convert number to CHAR
ORACLE DB SQL
By: hans_cellc on Sun, 16 February 2014
7 561 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 561 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 416 Sat, 15 February 2014 05:49
By: jgjeetu
  SELECT query gives error
Oracle 11g R2
By: rchenna on Thu, 13 February 2014
13 839 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 357 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 596 Fri, 14 February 2014 10:23
By: matspring1
  all_objects behaving differently when called from a pl/sql function (merged 3)
Oracle 11g
By: veeraiahmannem on Wed, 12 February 2014
5 522 Fri, 14 February 2014 09:31
By: Michel Cadot
  Total Time.
sql query
By: vik@s on Fri, 14 February 2014
2 387 Fri, 14 February 2014 04:02
By: Littlefoot
  PLS-00204: function or pseudo-column 'EXISTS' may be used inside a SQL statement
9i
By: ashwanth77 on Fri, 14 February 2014
3 348 Fri, 14 February 2014 03:32
By: dariyoosh
  Accessing the multi dimensional collection in SQL Query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Thu, 13 February 2014
5 529 Fri, 14 February 2014 02:20
By: saipradyumn
  check ordernum present in that column-PLS-00103: Encountered the symbol "SP_LOAD_ORDER" when expecti
9i
By: ashwanth77 on Fri, 14 February 2014
2 262 Fri, 14 February 2014 02:12
By: ashwanth77
  query help
By: mist598 on Fri, 14 February 2014
10 470 Fri, 14 February 2014 01:48
By: Michel Cadot
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: Tue Sep 23 04:01:13 CDT 2014

Total time taken to generate the page: 0.13412 seconds