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
  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 336 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 203 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 395 Fri, 14 February 2014 01:33
By: Michel Cadot
  converting clob to varchar2
SQL/PLSQL
By: gautham.gn on Thu, 13 February 2014
3 258 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 156 Thu, 13 February 2014 13:29
By: Michel Cadot
  Oracle SQL Developer questions
Oracle SQL Developer
By: Lahkra on Thu, 13 February 2014
9 331 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 319 Thu, 13 February 2014 08:26
By: mist598
  Query help
Oracle 11g Unix
By: nagaraju.ch on Thu, 13 February 2014
3 191 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 353 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 308 Wed, 12 February 2014 01:46
By: Michel Cadot
  UTL_MAIL
oracle 11g , windows os,
By: anncao on Mon, 10 February 2014
5 344 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 758 Tue, 11 February 2014 10:23
By: lott42
  Pragma Autonomous_transaction
By: vaibhav15211 on Tue, 11 February 2014
7 329 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 670 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 156 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 312 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 332 Sat, 08 February 2014 01:02
By: Kevin Meade
  parse blob into rows
Oracle 11g
By: mape on Sat, 28 December 2013
5 549 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 392 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 1446 Thu, 06 February 2014 12:15
By: Amine
  Result from Rows to Columns
Oracle 10g,Oracle11g
By: chandan.rattan on Tue, 29 October 2013
9 627 Thu, 06 February 2014 07:25
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: Sat Apr 19 13:04:05 CDT 2014

Total time taken to generate the page: 0.08329 seconds