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
  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 677 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 389 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 579 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 274 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 1308 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 288 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 759 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 364 Mon, 17 February 2014 00:18
By: msol25
  Convert number to CHAR
ORACLE DB SQL
By: hans_cellc on Sun, 16 February 2014
7 576 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 574 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 433 Sat, 15 February 2014 05:49
By: jgjeetu
  SELECT query gives error
Oracle 11g R2
By: rchenna on Thu, 13 February 2014
13 850 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 540 Fri, 14 February 2014 09:31
By: Michel Cadot
  Total Time.
sql query
By: vik@s on Fri, 14 February 2014
2 399 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 379 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 270 Fri, 14 February 2014 02:12
By: ashwanth77
  query help
By: mist598 on Fri, 14 February 2014
10 498 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 586 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
  Single quote issue in oracle
Oracle 11g
By: na.dharma@gmail.com on Thu, 13 February 2014
5 434 Thu, 13 February 2014 08:26
By: mist598
  Query help
Oracle 11g Unix
By: nagaraju.ch on Thu, 13 February 2014
3 270 Thu, 13 February 2014 06:58
By: cookiemonster
  Prevent Table Owner from Deleting Records of a Table
By: praveenramaswamy on Tue, 11 February 2014
19 891 Thu, 13 February 2014 03:04
By: Roachcoach
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 Oct 21 23:47:35 CDT 2014

Total time taken to generate the page: 0.08400 seconds