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
  IBM DB2 to Oracle PLSQL Current Day and day code conversion
By: pumelayurika on Fri, 12 June 2015
11 1588 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 1171 Fri, 12 June 2015 06:09
By: bugfox
  Duplicate Data
Oracle 11g
By: plsql_guy on Sat, 23 May 2015
36 1774 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 544 Thu, 11 June 2015 08:08
By: cookiemonster
  Difference
9i
By: glmjoy on Wed, 10 June 2015
5 609 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 989 Wed, 10 June 2015 00:54
By: Michel Cadot
  SQL query help
By: Developer9 on Mon, 08 June 2015
8 720 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 626 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 439 Tue, 09 June 2015 03:21
By: Michel Cadot
  ORA-30036 while running a Procedure
9i
By: Jaise on Mon, 08 June 2015
7 471 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 1151 Mon, 08 June 2015 07:36
By: BlackSwan
  SQL query help
oracle 11g
By: gorants on Sun, 07 June 2015
5 528 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 681 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 519 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 561 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 541 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 467 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 742 Wed, 03 June 2015 06:15
By: OraFerro
icon5.gif Question on Cursor
Oracle 11g Windows
By: brm2015 on Tue, 02 June 2015
4 476 Tue, 02 June 2015 08:06
By: Michel Cadot
  SQL & xml
By: sanodani on Tue, 02 June 2015
4 477 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 447 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 407 Mon, 01 June 2015 11:39
By: Michel Cadot
  dbms_scheduler
10g
By: m.abdulhaq on Fri, 29 May 2015
24 933 Mon, 01 June 2015 03:21
By: m.abdulhaq
  Recursive Hierarchy Help
By: kiekar on Thu, 21 May 2015
3 469 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 626 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 1038 Fri, 29 May 2015 11:10
By: shumail
  better query other than multiple for loop's?
By: mist598 on Fri, 29 May 2015
8 670 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 1015 Thu, 28 May 2015 14:50
By: BlackSwan
  Interview questions
By: purnima1 on Mon, 25 May 2015
8 959 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 934 Tue, 26 May 2015 14:01
By: John Watson
  Problem with calculating hours
oracle sql 10g
By: ifti6650 on Mon, 25 May 2015
9 614 Mon, 25 May 2015 10:13
By: BlackSwan
  Need Help on query
oracle 10g
By: samyms on Sun, 10 May 2015
9 752 Fri, 22 May 2015 08:19
By: BlackSwan
  Select max date in row of columns. . .
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: fluffycone on Thu, 21 May 2015
5 552 Thu, 21 May 2015 14:01
By: EdStevens
  string aggregation
oracle 11g
By: patneel on Thu, 21 May 2015
2 412 Thu, 21 May 2015 12:47
By: Michel Cadot
  date Format error
sql oracle
By: palpali on Thu, 21 May 2015
9 453 Thu, 21 May 2015 09:13
By: Bill B
  Error in execution of Trigger
oracle 10g
By: jgjeetu on Thu, 21 May 2015
11 527 Thu, 21 May 2015 08:49
By: Bill B
  does any one use oracle v12?
oracle v12
By: LargeHadronCollider on Thu, 21 May 2015
13 479 Thu, 21 May 2015 07:26
By: LargeHadronCollider
  Error using INTO clause in execute immediate
oracle 10g
By: jgjeetu on Thu, 21 May 2015
4 432 Thu, 21 May 2015 05:12
By: jgjeetu
  DELETING of RECORDS simultaneously.
By: saipavan.plsql on Wed, 20 May 2015
6 548 Thu, 21 May 2015 03:41
By: naga.oracle
  Date validation
11g
By: rohit_shinez on Sat, 16 May 2015
9 778 Wed, 20 May 2015 07:23
By: Lalit Kumar B
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: Thu Feb 11 00:44:05 CST 2016

Total time taken to generate the page: 0.12682 seconds