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
  update rows based on column values
oracle 10g
By: m.abdulhaq on Sun, 23 March 2014
11 553 Sun, 23 March 2014 09:27
By: m.abdulhaq
  sql query logic
oracle 10g
By: cvasi555 on Sat, 22 March 2014
7 319 Sun, 23 March 2014 01:04
By: Littlefoot
  count rows grouped by column name
By: carswelljr on Fri, 21 March 2014
5 312 Sat, 22 March 2014 01:41
By: Michel Cadot
  assign variable a calculated value in pl/sql
sql plus , windows 7
By: kevinb85 on Thu, 20 March 2014
12 514 Fri, 21 March 2014 04:57
By: cookiemonster
  Capturing OLD and NEW values from the Parameter of a sored procedure
11g
By: mapps0999@gmail.com on Wed, 19 March 2014
11 472 Fri, 21 March 2014 04:24
By: Michel Cadot
  Date and Last7Days
Oracle
By: nag.yalavarthi on Thu, 20 March 2014
1 206 Thu, 20 March 2014 17:19
By: BlackSwan
  Insert user_id if it doesn't already exist.
By: weatherman on Thu, 20 March 2014
5 178 Thu, 20 March 2014 12:19
By: cookiemonster
  can someone tell me why this sp takes so much time?
11g,toad 12.1
By: ashwanth77 on Mon, 17 March 2014
27 1174 Thu, 20 March 2014 11:48
By: cookiemonster
  Issue in inserting table data through DB Link
PL/SQL Release 11.2
By: Chinmay91 on Thu, 20 March 2014
2 104 Thu, 20 March 2014 08:46
By: Chinmay91
  Pivot concept in procedures
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Thu, 20 March 2014
2 157 Thu, 20 March 2014 08:16
By: saipradyumn
icon5.gif variable value's length is not checked during compilition
Oracle 11g, AIX
By: harpreetsinghkup on Fri, 14 March 2014
12 647 Thu, 20 March 2014 08:01
By: Solomon Yakobson
  difference between the two queries
Oracle 11g, Win7
By: nischalinn on Thu, 20 March 2014
2 113 Thu, 20 March 2014 07:29
By: cookiemonster
  pls 00103 error
11g,toad 12.1
By: ashwanth77 on Thu, 20 March 2014
3 150 Thu, 20 March 2014 04:15
By: Michel Cadot
  How to use application tracing in oracle
By: aaditya321 on Wed, 19 March 2014
21 645 Thu, 20 March 2014 02:43
By: Michel Cadot
  Writing SQL Query
Oracle
By: rlsublime on Wed, 19 March 2014
1 163 Wed, 19 March 2014 19:30
By: BlackSwan
  help with xml parsing
Oracle Database 11.2.0.2.0
By: Roger22 on Wed, 19 March 2014
1 154 Wed, 19 March 2014 19:16
By: Solomon Yakobson
  Doubt with Associative Arrays
Oracle 9i, Solaris 10 Operating System
By: akull on Wed, 19 March 2014
8 427 Wed, 19 March 2014 17:15
By: ThomasG
  Replace Date column to Varchar Value
Windows
By: amit_jha05 on Tue, 18 March 2014
19 593 Wed, 19 March 2014 12:37
By: joy_division
  Rename Tablespace
Oracle 11.2.0.3.0 ,Linux
By: Jack14 on Tue, 18 March 2014
9 442 Wed, 19 March 2014 12:23
By: Michel Cadot
  Data validation in staging table
By: anujindia12 on Wed, 19 March 2014
9 406 Wed, 19 March 2014 10:14
By: John Watson
  string to number conversion
oracle 11g
By: meeplsql on Wed, 19 March 2014
10 415 Wed, 19 March 2014 08:44
By: Michel Cadot
  Difference between share & Exclusive Locks
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Wed, 19 March 2014
5 290 Wed, 19 March 2014 08:36
By: Michel Cadot
  I Object to that Cursor record!
PL/SQL 11G R2 Database Packages
By: msheda on Mon, 17 March 2014
7 456 Wed, 19 March 2014 08:13
By: msheda
  how to find data using date as a parameter in financial year
By: jgjeetu on Wed, 19 March 2014
1 127 Wed, 19 March 2014 05:54
By: cookiemonster
  SQL solution needed - urgent!
By: Annie Agarwal on Tue, 18 March 2014
14 626 Wed, 19 March 2014 04:36
By: cookiemonster
  timestamp shows 0 for all the records
11g,toad 12.1
By: ashwanth77 on Tue, 18 March 2014
6 369 Wed, 19 March 2014 04:17
By: cookiemonster
  Query taking Too much time
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
By: naveen_erp on Wed, 19 March 2014
1 164 Wed, 19 March 2014 00:08
By: BlackSwan
  Adding spaces to the column value
By: callmevj on Tue, 18 March 2014
9 398 Tue, 18 March 2014 15:01
By: Michel Cadot
  Help with grouping documents
Oracle 10g
By: krajesiu on Tue, 18 March 2014
4 272 Tue, 18 March 2014 08:16
By: Michel Cadot
  How to update the foreign key table
By: mist598 on Tue, 18 March 2014
16 635 Tue, 18 March 2014 06:42
By: mist598
  ORA-06504: PL/SQL: Return types of Result Set variables or query do not match
By: mist598 on Tue, 18 March 2014
8 398 Tue, 18 March 2014 03:07
By: mist598
  PL/SQL SYS_REFCURSOR Missing Data
Oracle Database 11g Enterprise Edition, 11.2.0.3.0, Windows Server 2003
By: annagel on Mon, 17 March 2014
6 301 Tue, 18 March 2014 01:05
By: Michel Cadot
  Instance Sequence Priority Values
Oracle 11g
By: developer12 on Mon, 17 March 2014
8 372 Mon, 17 March 2014 11:21
By: Michel Cadot
  merge 2 rows
pl sql
By: yesh on Mon, 17 March 2014
2 193 Mon, 17 March 2014 11:06
By: LKBrwn_DBA
  AutoCommit in Stored Proc
oracle 11g
By: feroze on Thu, 13 March 2014
5 369 Mon, 17 March 2014 08:25
By: cookiemonster
  File/Folder write permission in Oracle via Java Policy
Oracle 11g
By: didiera123 on Fri, 14 March 2014
2 280 Mon, 17 March 2014 00:36
By: didiera123
  PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
Oracle 10g
By: rvsri on Sun, 16 March 2014
5 222 Sun, 16 March 2014 09:47
By: BlackSwan
  How to do parallel inserts without changing table parallel degree
Oracle Database 11.2.0.3 Enterprise Edition
By: manubatham20 on Fri, 14 March 2014
2 238 Sun, 16 March 2014 02:41
By: John Watson
  Unknown number for looping-Logic
10g
By: dev1983 on Fri, 14 March 2014
3 346 Sat, 15 March 2014 18:21
By: dev1983
  Jpublisher is giving error while generating the class ? ? ?
By: rameshbandari777@gmail.co on Fri, 14 March 2014
1 134 Fri, 14 March 2014 12:09
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: Fri Apr 18 21:19:22 CDT 2014

Total time taken to generate the page: 0.13671 seconds