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
  Query to get Status of Students as 'Pass' or 'Fail' Using Date Condition
Oracle 11g
By: sonudev on Wed, 12 February 2014
3 307 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 247 Mon, 17 February 2014 04:26
By: hans_cellc
  FLASHBACK QUERY
11g r2
By: mvrkr44 on Sun, 16 February 2014
7 570 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 629 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 692 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 331 Mon, 17 February 2014 00:18
By: msol25
  Convert number to CHAR
ORACLE DB SQL
By: hans_cellc on Sun, 16 February 2014
7 512 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 521 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 370 Sat, 15 February 2014 05:49
By: jgjeetu
  SELECT query gives error
Oracle 11g R2
By: rchenna on Thu, 13 February 2014
13 793 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 325 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 551 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 480 Fri, 14 February 2014 09:31
By: Michel Cadot
  Total Time.
sql query
By: vik@s on Fri, 14 February 2014
2 353 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 307 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 482 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 237 Fri, 14 February 2014 02:12
By: ashwanth77
  query help
By: mist598 on Fri, 14 February 2014
10 425 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 506 Fri, 14 February 2014 01:33
By: Michel Cadot
  converting clob to varchar2
SQL/PLSQL
By: gautham.gn on Thu, 13 February 2014
3 350 Fri, 14 February 2014 01:09
By: Michel Cadot
  retrieve data from 4 tables
oracle 11g
By: stevefaulk on Mon, 10 February 2014
1 314 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 283 Thu, 13 February 2014 13:49
By: Solomon Yakobson
  n00b question
linux , oracle 11gR2
By: cozsmin on Thu, 13 February 2014
2 198 Thu, 13 February 2014 13:29
By: Michel Cadot
  Oracle SQL Developer questions
Oracle SQL Developer
By: Lahkra on Thu, 13 February 2014
9 418 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 375 Thu, 13 February 2014 08:26
By: mist598
  Query help
Oracle 11g Unix
By: nagaraju.ch on Thu, 13 February 2014
3 240 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 823 Thu, 13 February 2014 03:04
By: Roachcoach
  PLS-00302: component must be declared
Ora 11.2.0
By: mjm22 on Wed, 12 February 2014
2 409 Wed, 12 February 2014 16:24
By: mjm22
  cursor lock for individual transactions
Oracle 10g
By: sss111ind on Tue, 11 February 2014
9 474 Wed, 12 February 2014 10:25
By: sss111ind
  Constraints., (merged 2)
By: Rarawshenkiv on Wed, 12 February 2014
1 149 Wed, 12 February 2014 06:47
By: rleishman
icon5.gif Oracle SQL help needed
Oracle 10 g
By: Mike_Fennell on Tue, 11 February 2014
5 369 Wed, 12 February 2014 04:27
By: Littlefoot
  string leteral updation
Oracle 11g xp
By: sunilreddy on Wed, 12 February 2014
4 208 Wed, 12 February 2014 03:58
By: Littlefoot
  Sorting data in Nested table
By: babar82 on Mon, 27 January 2014
5 384 Wed, 12 February 2014 01:46
By: Michel Cadot
  UTL_MAIL
oracle 11g , windows os,
By: anncao on Mon, 10 February 2014
5 422 Tue, 11 February 2014 12:29
By: anncao
  Connect by Prior parent-child into string of values
10.2
By: lott42 on Fri, 07 February 2014
14 864 Tue, 11 February 2014 10:23
By: lott42
  Pragma Autonomous_transaction
By: vaibhav15211 on Tue, 11 February 2014
7 427 Tue, 11 February 2014 09:03
By: Michel Cadot
  trigger when insert into select
oracle sql developer 10g
By: preethia on Tue, 11 February 2014
4 286 Tue, 11 February 2014 08:29
By: preethia
  Number & Numeric & integer what is the difference
oralce 11g
By: amirtharaj on Mon, 10 February 2014
5 344 Tue, 11 February 2014 05:24
By: msol25
  Error in PL/SQL Procedure using UTL_HTTP
Oracle 10g
By: sarfraz_attari on Tue, 04 February 2014
12 941 Tue, 11 February 2014 02:19
By: sarfraz_attari
icon5.gif Help Writing a Complex 'SELECT' Query
Oracle 11, Windows
By: johnjacobt on Sun, 09 February 2014
7 502 Mon, 10 February 2014 23:08
By: johnjacobt
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 Aug 01 08:16:57 CDT 2014

Total time taken to generate the page: 0.08747 seconds