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
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 449 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 566 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 1013 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 492 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 678 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 351 Wed, 19 February 2014 00:53
By: Michel Cadot
  Struggling with DBMS_JOB.SUBMIT syntax
11g
By: bristolsmithy on Tue, 18 February 2014
3 542 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 391 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 419 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 580 Tue, 18 February 2014 11:07
By: BlackSwan
  First Character in "numeric-Alpha"
10.2.0
By: bluetooth420 on Mon, 10 February 2014
9 691 Tue, 18 February 2014 07:03
By: cookiemonster
  Oracle Compare 2 Tables
11g
By: developer12 on Tue, 18 February 2014
1 275 Tue, 18 February 2014 05:54
By: Michel Cadot
  not in, not exists query
By: mist598 on Mon, 17 February 2014
15 980 Tue, 18 February 2014 04:04
By: cookiemonster
  materialized view
oracle 10 g
By: oraclehi on Tue, 18 February 2014
5 403 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 1309 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 652 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 355 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 290 Mon, 17 February 2014 04:26
By: hans_cellc
  FLASHBACK QUERY
11g r2
By: mvrkr44 on Sun, 16 February 2014
7 620 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 669 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 760 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 366 Mon, 17 February 2014 00:18
By: msol25
  Convert number to CHAR
ORACLE DB SQL
By: hans_cellc on Sun, 16 February 2014
7 577 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 576 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 434 Sat, 15 February 2014 05:49
By: jgjeetu
  SELECT query gives error
Oracle 11g R2
By: rchenna on Thu, 13 February 2014
13 853 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 371 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 616 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 542 Fri, 14 February 2014 09:31
By: Michel Cadot
  Total Time.
sql query
By: vik@s on Fri, 14 February 2014
2 400 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 381 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 550 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 271 Fri, 14 February 2014 02:12
By: ashwanth77
  query help
By: mist598 on Fri, 14 February 2014
10 500 Fri, 14 February 2014 01:48
By: Michel Cadot
  Convert rows into columns
oracle 10g,win xp
By: Xandot on Thu, 13 February 2014
6 590 Fri, 14 February 2014 01:33
By: Michel Cadot
  converting clob to varchar2
SQL/PLSQL
By: gautham.gn on Thu, 13 February 2014
3 401 Fri, 14 February 2014 01:09
By: Michel Cadot
  retrieve data from 4 tables
oracle 11g
By: stevefaulk on Mon, 10 February 2014
1 334 Thu, 13 February 2014 15:06
By: LKBrwn_DBA
  Error when calling a function that returns a pipeline from another function
By: ora1980 on Thu, 13 February 2014
2 334 Thu, 13 February 2014 13:49
By: Solomon Yakobson
  n00b question
linux , oracle 11gR2
By: cozsmin on Thu, 13 February 2014
2 225 Thu, 13 February 2014 13:29
By: Michel Cadot
  Oracle SQL Developer questions
Oracle SQL Developer
By: Lahkra on Thu, 13 February 2014
9 495 Thu, 13 February 2014 09:41
By: Lahkra
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 Oct 23 07:37:32 CDT 2014

Total time taken to generate the page: 0.09283 seconds