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
  PLS-00204: function or pseudo-column 'EXISTS' may be used inside a SQL statement
9i
By: ashwanth77 on Fri, 14 February 2014
3 218 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 337 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 204 Fri, 14 February 2014 02:12
By: ashwanth77
  query help
By: mist598 on Fri, 14 February 2014
10 349 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 396 Fri, 14 February 2014 01:33
By: Michel Cadot
  converting clob to varchar2
SQL/PLSQL
By: gautham.gn on Thu, 13 February 2014
3 263 Fri, 14 February 2014 01:09
By: Michel Cadot
  retrieve data from 4 tables
oracle 11g
By: stevefaulk on Mon, 10 February 2014
1 245 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 179 Thu, 13 February 2014 13:49
By: Solomon Yakobson
  n00b question
linux , oracle 11gR2
By: cozsmin on Thu, 13 February 2014
2 157 Thu, 13 February 2014 13:29
By: Michel Cadot
  Oracle SQL Developer questions
Oracle SQL Developer
By: Lahkra on Thu, 13 February 2014
9 332 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 320 Thu, 13 February 2014 08:26
By: mist598
  Query help
Oracle 11g Unix
By: nagaraju.ch on Thu, 13 February 2014
3 192 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 728 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 260 Wed, 12 February 2014 16:24
By: mjm22
  cursor lock for individual transactions
Oracle 10g
By: sss111ind on Tue, 11 February 2014
9 356 Wed, 12 February 2014 10:25
By: sss111ind
  Constraints., (merged 2)
By: Rarawshenkiv on Wed, 12 February 2014
1 113 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 288 Wed, 12 February 2014 04:27
By: Littlefoot
  string leteral updation
Oracle 11g xp
By: sunilreddy on Wed, 12 February 2014
4 158 Wed, 12 February 2014 03:58
By: Littlefoot
  Sorting data in Nested table
By: babar82 on Mon, 27 January 2014
5 309 Wed, 12 February 2014 01:46
By: Michel Cadot
  UTL_MAIL
oracle 11g , windows os,
By: anncao on Mon, 10 February 2014
5 346 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 759 Tue, 11 February 2014 10:23
By: lott42
  Pragma Autonomous_transaction
By: vaibhav15211 on Tue, 11 February 2014
7 330 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 226 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 292 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 672 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 426 Mon, 10 February 2014 23:08
By: johnjacobt
  ORA-4091- Mutating Trigger Error
By: praveenramaswamy on Thu, 06 February 2014
11 432 Mon, 10 February 2014 12:12
By: praveenramaswamy
  ORA-08177
Oracle 10g
By: sss111ind on Mon, 10 February 2014
1 158 Mon, 10 February 2014 10:58
By: BlackSwan
  Looping in a For loop
Oracle 10g
By: sss111ind on Mon, 10 February 2014
8 393 Mon, 10 February 2014 10:44
By: cookiemonster
  Pragma autonoums transaction
By: mvrkr44 on Mon, 10 February 2014
4 263 Mon, 10 February 2014 06:21
By: Michel Cadot
  NESTED TABLE & Analytical functions
11.2.0.3
By: rishwinger on Mon, 10 February 2014
2 185 Mon, 10 February 2014 04:44
By: rishwinger
  Boolean Data type usage in PL/SQl Block
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Mon, 10 February 2014
1 140 Mon, 10 February 2014 03:58
By: cookiemonster
  SU@RE#SH$ i want the output as SURESH
11g
By: ashwanth77 on Sun, 09 February 2014
2 214 Sun, 09 February 2014 14:10
By: Michel Cadot
  for loop
11g
By: ggggg on Sun, 09 February 2014
5 314 Sun, 09 February 2014 09:08
By: BlackSwan
  Execute sequence once per select
Oracle 10g
By: sss111ind on Sat, 08 February 2014
5 367 Sat, 08 February 2014 05:17
By: sss111ind
  etl script, same database, two different schemas
Oracle 11g
By: frunzaverde on Fri, 07 February 2014
5 333 Sat, 08 February 2014 01:02
By: Kevin Meade
  parse blob into rows
Oracle 11g
By: mape on Sat, 28 December 2013
5 552 Fri, 07 February 2014 08:00
By: mape
  how to find number of days in a given month.
SQL PLUS ORACLE 10G
By: jgjeetu on Fri, 07 February 2014
5 398 Fri, 07 February 2014 01:34
By: jgjeetu
  user creation
oracle 11
By: ykozhevnikov on Thu, 06 February 2014
3 163 Thu, 06 February 2014 23:19
By: manubatham20
  Materialized views to rescue "mutating tables"
release 1102000100
By: Amine on Sun, 20 October 2013
23 1448 Thu, 06 February 2014 12:15
By: Amine
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: Mon Apr 21 01:44:10 CDT 2014

Total time taken to generate the page: 0.07309 seconds