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
  Please help - comma separated values
Oracle Database 11g Release 11.2.0.3.0
By: oralover2006 on Wed, 26 March 2014
6 409 Wed, 26 March 2014 05:50
By: oralover2006
  Oracle transpose rows into columns
Oracle 11g
By: developer12 on Mon, 24 March 2014
12 967 Wed, 26 March 2014 03:13
By: Michel Cadot
  if in field value "Delete", then don't join other table
Oracle 10g
By: rc3d on Mon, 24 March 2014
5 481 Tue, 25 March 2014 05:56
By: cookiemonster
  Insufficient privileges in DBMS_SESSION.SET_CONTEXT
Oracle 11.2.0.1.0 on OEL 5.7
By: Andrey_R on Sun, 23 March 2014
4 836 Tue, 25 March 2014 04:57
By: Andrey_R
  Dynamic column selection
11g
By: okela_vp on Tue, 10 December 2013
6 630 Tue, 25 March 2014 00:14
By: Barbara Boehmer
  Problem in external table ( 1 2)
By: aaditya321 on Tue, 11 March 2014
65 3286 Mon, 24 March 2014 13:10
By: aaditya321
  Insert statements
Oracle 11g
By: srinivas.k2005 on Wed, 12 March 2014
4 419 Mon, 24 March 2014 12:38
By: Michel Cadot
  generate xls file through pl/sql
By: tisekofti on Sat, 22 March 2014
7 638 Mon, 24 March 2014 08:27
By: cookiemonster
  computing statistics at the schema level
11g
By: ashwanth77 on Mon, 24 March 2014
2 263 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 300 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 259 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 527 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 328 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 187 Mon, 24 March 2014 03:44
By: Littlefoot
  Time Elapsed
By: mist598 on Wed, 19 March 2014
9 670 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 773 Sun, 23 March 2014 09:27
By: m.abdulhaq
  sql query logic
oracle 10g
By: cvasi555 on Sat, 22 March 2014
7 476 Sun, 23 March 2014 01:04
By: Littlefoot
  count rows grouped by column name
By: carswelljr on Fri, 21 March 2014
5 488 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 818 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 605 Fri, 21 March 2014 04:24
By: Michel Cadot
  Date and Last7Days
Oracle
By: nag.yalavarthi on Thu, 20 March 2014
1 339 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 312 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 1415 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 215 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 830 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 237 Thu, 20 March 2014 07:29
By: cookiemonster
  pls 00103 error
11g,toad 12.1
By: ashwanth77 on Thu, 20 March 2014
3 259 Thu, 20 March 2014 04:15
By: Michel Cadot
  How to use application tracing in oracle
By: aaditya321 on Wed, 19 March 2014
21 854 Thu, 20 March 2014 02:43
By: Michel Cadot
  Writing SQL Query
Oracle
By: rlsublime on Wed, 19 March 2014
1 248 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 568 Wed, 19 March 2014 17:15
By: ThomasG
  Replace Date column to Varchar Value
Windows
By: amit_jha05 on Tue, 18 March 2014
19 809 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 568 Wed, 19 March 2014 12:23
By: Michel Cadot
  Data validation in staging table
By: anujindia12 on Wed, 19 March 2014
9 623 Wed, 19 March 2014 10:14
By: John Watson
  string to number conversion
oracle 11g
By: meeplsql on Wed, 19 March 2014
10 573 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 423 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 627 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 228 Wed, 19 March 2014 05:54
By: cookiemonster
  SQL solution needed - urgent!
By: Annie Agarwal on Tue, 18 March 2014
14 879 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 517 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 294 Wed, 19 March 2014 00:08
By: BlackSwan
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 Nov 21 15:01:25 CST 2014

Total time taken to generate the page: 0.15792 seconds