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
  Insert statements
Oracle 11g
By: srinivas.k2005 on Wed, 12 March 2014
4 354 Mon, 24 March 2014 12:38
By: Michel Cadot
  generate xls file through pl/sql
By: tisekofti on Sat, 22 March 2014
7 553 Mon, 24 March 2014 08:27
By: cookiemonster
  computing statistics at the schema level
11g
By: ashwanth77 on Mon, 24 March 2014
2 221 Mon, 24 March 2014 07:40
By: EdStevens
  comparing the result of multiple SELECT statements
Oracle 11g, Win7
By: nischalinn on Mon, 24 March 2014
5 218 Mon, 24 March 2014 07:10
By: Michel Cadot
icon4.gif How? - Create Check constraint - field must contain @ symbol
Oracle llg Apex
By: Oracleuser14 on Mon, 24 March 2014
2 193 Mon, 24 March 2014 06:52
By: Michel Cadot
  Error while executing the plsql block for mview refresh
oracle 11g
By: narendra.treddi on Thu, 20 March 2014
10 380 Mon, 24 March 2014 06:46
By: Michel Cadot
  Please help for ORA-01416: two tables cannot be outer-joined to each other
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Mon, 24 March 2014
4 208 Mon, 24 March 2014 04:39
By: msol25
  How to display Last Day In Week Indicate As Y or N as input is start date and end date
Windows
By: spatil522@gmail.com on Mon, 24 March 2014
1 149 Mon, 24 March 2014 03:44
By: Littlefoot
  Time Elapsed
By: mist598 on Wed, 19 March 2014
9 587 Mon, 24 March 2014 01:49
By: vslabs
  update rows based on column values
oracle 10g
By: m.abdulhaq on Sun, 23 March 2014
11 663 Sun, 23 March 2014 09:27
By: m.abdulhaq
  sql query logic
oracle 10g
By: cvasi555 on Sat, 22 March 2014
7 385 Sun, 23 March 2014 01:04
By: Littlefoot
  count rows grouped by column name
By: carswelljr on Fri, 21 March 2014
5 407 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 662 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 527 Fri, 21 March 2014 04:24
By: Michel Cadot
  Date and Last7Days
Oracle
By: nag.yalavarthi on Thu, 20 March 2014
1 285 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 257 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 1318 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 156 Thu, 20 March 2014 08:46
By: Chinmay91
icon5.gif variable value's length is not checked during compilition
Oracle 11g, AIX
By: harpreetsinghkup on Fri, 14 March 2014
12 733 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 175 Thu, 20 March 2014 07:29
By: cookiemonster
  pls 00103 error
11g,toad 12.1
By: ashwanth77 on Thu, 20 March 2014
3 193 Thu, 20 March 2014 04:15
By: Michel Cadot
  How to use application tracing in oracle
By: aaditya321 on Wed, 19 March 2014
21 765 Thu, 20 March 2014 02:43
By: Michel Cadot
  Writing SQL Query
Oracle
By: rlsublime on Wed, 19 March 2014
1 210 Wed, 19 March 2014 19:30
By: BlackSwan
  Doubt with Associative Arrays
Oracle 9i, Solaris 10 Operating System
By: akull on Wed, 19 March 2014
8 513 Wed, 19 March 2014 17:15
By: ThomasG
  Replace Date column to Varchar Value
Windows
By: amit_jha05 on Tue, 18 March 2014
19 701 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 496 Wed, 19 March 2014 12:23
By: Michel Cadot
  Data validation in staging table
By: anujindia12 on Wed, 19 March 2014
9 533 Wed, 19 March 2014 10:14
By: John Watson
  string to number conversion
oracle 11g
By: meeplsql on Wed, 19 March 2014
10 492 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 362 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 542 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 189 Wed, 19 March 2014 05:54
By: cookiemonster
  SQL solution needed - urgent!
By: Annie Agarwal on Tue, 18 March 2014
14 733 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 439 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 243 Wed, 19 March 2014 00:08
By: BlackSwan
  Adding spaces to the column value
By: callmevj on Tue, 18 March 2014
9 504 Tue, 18 March 2014 15:01
By: Michel Cadot
  Help with grouping documents
Oracle 10g
By: krajesiu on Tue, 18 March 2014
4 334 Tue, 18 March 2014 08:16
By: Michel Cadot
  How to update the foreign key table
By: mist598 on Tue, 18 March 2014
16 707 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 519 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 378 Tue, 18 March 2014 01:05
By: Michel Cadot
  Instance Sequence Priority Values
Oracle 11g
By: developer12 on Mon, 17 March 2014
8 421 Mon, 17 March 2014 11:21
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: Mon Jul 28 17:43:24 CDT 2014

Total time taken to generate the page: 0.12445 seconds