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
  Cross tab SQL query
Oracle 9i
By: tarasasu on Mon, 15 June 2015
13 1075 Fri, 19 June 2015 03:23
By: pablolee
  Function declartation
oracle 10g
By: arun888 on Fri, 19 June 2015
3 395 Fri, 19 June 2015 02:40
By: arun888
  dynamic input value passing
ORACLE 10G
By: arun888 on Thu, 18 June 2015
3 433 Thu, 18 June 2015 09:47
By: Michel Cadot
  PL SQL - Need to create archive table - [MERGED]
By: rajivgandhiram on Tue, 16 June 2015
6 735 Wed, 17 June 2015 01:42
By: Lalit Kumar B
  Create VIEW retrieving from dynamically configured table/queries
By: gtriant on Thu, 11 June 2015
20 1084 Tue, 16 June 2015 16:03
By: gtriant
  How To Check Images with Zero Bytes in Size on BLOB column datatype
Oracle 11.2.0.3.0
By: wtolentino on Mon, 15 June 2015
9 778 Tue, 16 June 2015 07:20
By: wtolentino
  Sysdate with time interval parameter
Oracle 11i
By: RADHAKAN on Mon, 15 June 2015
16 955 Tue, 16 June 2015 03:22
By: Michel Cadot
  Read a string char by char and compare
Oracle 11g Solaris 11
By: apenkov on Mon, 15 June 2015
11 835 Tue, 16 June 2015 02:06
By: apenkov
  How to alter the varchar column to number datatype
oracle 11i
By: Jothish on Fri, 12 June 2015
25 2115 Mon, 15 June 2015 03:02
By: pablolee
  Interview Question
oracle 11g
By: anniepeteroracle on Mon, 15 June 2015
4 596 Mon, 15 June 2015 02:06
By: Lalit Kumar B
  IBM DB2 to Oracle PLSQL Current Day and day code conversion
By: pumelayurika on Fri, 12 June 2015
11 1703 Mon, 15 June 2015 00:06
By: Michel Cadot
  merge columns from 2 different tables
oracle 10g
By: nciteamo on Fri, 12 June 2015
1 1255 Fri, 12 June 2015 06:09
By: bugfox
  Duplicate Data
Oracle 11g
By: plsql_guy on Sat, 23 May 2015
36 1888 Fri, 12 June 2015 03:11
By: Michel Cadot
  Procedure or Function
Oracle 109, Windows Server / 7
By: roni_a180 on Thu, 11 June 2015
3 629 Thu, 11 June 2015 08:08
By: cookiemonster
  Difference
9i
By: glmjoy on Wed, 10 June 2015
5 714 Wed, 10 June 2015 23:59
By: Michel Cadot
  What we should use for better function or procedure
By: aaditya321 on Mon, 18 August 2014
10 1061 Wed, 10 June 2015 00:54
By: Michel Cadot
  SQL query help
By: Developer9 on Mon, 08 June 2015
8 797 Wed, 10 June 2015 00:50
By: Michel Cadot
  cumulative sum
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
By: naga.oracle on Tue, 09 June 2015
9 726 Tue, 09 June 2015 11:53
By: naga.oracle
  Fast query paging for large table
Oracle 12c,Oracle Linux 6.4
By: fabi88 on Tue, 09 June 2015
3 508 Tue, 09 June 2015 03:21
By: Michel Cadot
  ORA-30036 while running a Procedure
9i
By: Jaise on Mon, 08 June 2015
7 536 Mon, 08 June 2015 14:55
By: Michel Cadot
  ORA-02437: cannot validate (TAGICRM.PK_RISK_GRID) - primary key violated
11g, 11.2.0.1, window7
By: ashishkumarmahanta80 on Tue, 02 June 2015
12 1324 Mon, 08 June 2015 07:36
By: BlackSwan
  SQL query help
oracle 11g
By: gorants on Sun, 07 June 2015
5 590 Mon, 08 June 2015 01:40
By: Lalit Kumar B
  Date range from table
Oracle 11G, Windows 7
By: mach_9 on Thu, 04 June 2015
6 763 Fri, 05 June 2015 04:42
By: Littlefoot
icon5.gif Invalid table alias with left join behaves differently on different versions
Ver : 10.2.0.5, 11.2.0.2, 11.2.0.3, 12.1.0.1 OS : Windows, Linux
By: Lalit Kumar B on Fri, 05 June 2015
3 626 Fri, 05 June 2015 04:10
By: Lalit Kumar B
  How to get recursive result
Oracle 11.2.0.1.0 - 64bit, Linux
By: gold_oracl on Wed, 03 June 2015
2 631 Thu, 04 June 2015 09:10
By: gold_oracl
  Show the total of records with last record
11.2.0.1.0
By: OraFerro on Thu, 04 June 2015
7 621 Thu, 04 June 2015 05:35
By: OraFerro
  compare columns in two tables and trigger something when the condn fails
By: kiranrathodkr916 on Thu, 04 June 2015
1 523 Thu, 04 June 2015 03:47
By: Lalit Kumar B
  Create dummy records using Model clause with condition for date field
11.2.0.1.0
By: OraFerro on Mon, 01 June 2015
3 825 Wed, 03 June 2015 06:15
By: OraFerro
icon5.gif Question on Cursor
Oracle 11g Windows
By: brm2015 on Tue, 02 June 2015
4 543 Tue, 02 June 2015 08:06
By: Michel Cadot
  SQL & xml
By: sanodani on Tue, 02 June 2015
4 523 Tue, 02 June 2015 06:00
By: Michel Cadot
icon5.gif Inserting mathematical symbol ≤ in Oracle table
Oracle 11g
By: Roshnie on Tue, 02 June 2015
4 519 Tue, 02 June 2015 02:54
By: Lalit Kumar B
  select first row after appying order by for multiple records
oracle 11g
By: knowit2015 on Mon, 01 June 2015
2 509 Mon, 01 June 2015 11:39
By: Michel Cadot
  dbms_scheduler
10g
By: m.abdulhaq on Fri, 29 May 2015
24 1055 Mon, 01 June 2015 03:21
By: m.abdulhaq
  Recursive Hierarchy Help
By: kiekar on Thu, 21 May 2015
3 554 Sun, 31 May 2015 13:45
By: Michel Cadot
  Displaying calculated field with selected rows and Adding row according to date condition
11.2.0.1.0
By: OraFerro on Thu, 28 May 2015
5 737 Sat, 30 May 2015 23:50
By: OraFerro
  Identify bottlenecks in queries
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Sun, 24 May 2015
13 1127 Fri, 29 May 2015 11:10
By: shumail
  better query other than multiple for loop's?
By: mist598 on Fri, 29 May 2015
8 767 Fri, 29 May 2015 09:43
By: BlackSwan
  Increasing Initrans for Partitioned table without re-creating it
Oracle 11g (11.2.0.4)
By: venkatesh_b on Wed, 27 May 2015
11 1402 Thu, 28 May 2015 14:50
By: BlackSwan
  Interview questions
By: purnima1 on Mon, 25 May 2015
8 1029 Thu, 28 May 2015 01:25
By: Michel Cadot
  Procedure is taking more time to execute
oracle 10g windows 7
By: nayana08 on Thu, 21 May 2015
22 1025 Tue, 26 May 2015 14:01
By: John Watson
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: Tue May 31 07:54:31 CDT 2016

Total time taken to generate the page: 0.21968 seconds