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
  Merge using row order
11.2.0.1.0
By: OraFerro on Tue, 14 July 2015
3 411 Wed, 15 July 2015 00:02
By: Michel Cadot
  Same serial for a group
Oracle 11g
By: vspn on Mon, 06 July 2015
30 1350 Tue, 14 July 2015 23:59
By: Michel Cadot
  Disabling unique constraints and data warehousing query
By: GusGF on Tue, 14 July 2015
5 329 Tue, 14 July 2015 05:10
By: GusGF
  Rowcount
Oracle 11g
By: thiruvari on Mon, 13 July 2015
9 478 Tue, 14 July 2015 04:48
By: Michel Cadot
  Select Query based on closed / reopened flag
By: simramkumar on Mon, 13 July 2015
5 310 Mon, 13 July 2015 04:50
By: Michel Cadot
  To tune a PL/SQL block
12c, 11g
By: 13478 on Sun, 12 July 2015
6 447 Mon, 13 July 2015 03:27
By: cookiemonster
  Variable in PLSQL
PLSQL Version 9
By: rbs100 on Sun, 12 July 2015
2 328 Sun, 12 July 2015 09:29
By: BlackSwan
  Swift message insert script
oracle 11g
By: Nusrat on Mon, 06 July 2015
10 856 Sun, 12 July 2015 02:22
By: Nusrat
  Default Value
11g database
By: cool06prashant on Fri, 10 July 2015
3 351 Sat, 11 July 2015 00:36
By: Michel Cadot
  ORA-2014 on RLS-enabled table with double FGA policy
RDBMS 11.2.0.3, Windows 2008 R2, 64-bit
By: Alien on Fri, 10 July 2015
0 402 Fri, 10 July 2015 14:43
By: Alien
  Interesting explain plan output/puzzle
11.2.0.4.0
By: Roachcoach on Mon, 06 July 2015
8 2402 Fri, 10 July 2015 14:27
By: Alien
  Get data from various partitions with having one extra column
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Wed, 08 July 2015
12 586 Thu, 09 July 2015 05:18
By: pablolee
  Partition table - High_Value in DD-MON-YYYY format
Oracle 11.2.0.3, Linux x86 64
By: hitesh.bhatt on Thu, 09 July 2015
3 432 Thu, 09 July 2015 05:17
By: Michel Cadot
  How to use computed result of one row in the next row for inserting in table
Oracle 11g
By: raman.virk on Thu, 09 July 2015
0 502 Thu, 09 July 2015 02:33
By: raman.virk
  How to update substring using sql
oracle 11g
By: gorants on Wed, 08 July 2015
6 437 Wed, 08 July 2015 12:07
By: BlackSwan
  Extracting the Numeric values from a column in oracle
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: msinha8 on Tue, 07 July 2015
2 300 Tue, 07 July 2015 08:53
By: msinha8
  PL/SQL Cursor
Oracle Database 12.1.0.2; Centos
By: nqtrung on Tue, 07 July 2015
12 495 Tue, 07 July 2015 03:57
By: pablolee
  SQL query help
oracle 11g
By: gorants on Mon, 06 July 2015
8 468 Tue, 07 July 2015 00:05
By: Michel Cadot
  To get start and end date of month
By: rohit_shinez on Mon, 06 July 2015
26 663 Mon, 06 July 2015 12:40
By: BlackSwan
  Oracle SQL Customization
Oracle 12C
By: deepakdot on Sat, 04 July 2015
12 533 Mon, 06 July 2015 07:02
By: deepakdot
  DRL for a particular condition
By: saipavan.plsql on Mon, 06 July 2015
3 292 Mon, 06 July 2015 05:00
By: Michel Cadot
  want to delete 42k duplicate rows from table 18 mill rows
10g
By: cplusplus1 on Wed, 01 July 2015
19 994 Mon, 06 July 2015 02:32
By: pablolee
  Last four weeks data
Oracle 12c
By: imranhemani on Sun, 05 July 2015
2 314 Mon, 06 July 2015 00:02
By: Michel Cadot
  need select query based on pl sql table
oracle 11g
By: mvrkr44 on Mon, 29 June 2015
2 340 Sun, 05 July 2015 00:48
By: Kevin Meade
  SQL Where Limitation
Linux RHAT 6.5 on using oracle 11.2.0.4
By: ma251436 on Mon, 29 June 2015
6 616 Sun, 05 July 2015 00:45
By: Kevin Meade
icon4.gif Data selection on basis of columns from two consecutive rows (merged)
11g oracle database , window os
By: pankajmaurya55 on Sat, 04 July 2015
8 48690 Sat, 04 July 2015 04:57
By: Lalit Kumar B
icon4.gif SUM CASE date difference calculation
Oracle SQL
By: bowgieman on Thu, 02 July 2015
16 795 Fri, 03 July 2015 11:07
By: Lalit Kumar B
  construct full date based on value yyyymm
11g
By: cplusplus1 on Fri, 23 January 2015
26 1286 Thu, 02 July 2015 11:27
By: Lalit Kumar B
  REGEXP_REPLACE for different name variations
Oracle 11g
By: madsen on Wed, 01 July 2015
5 362 Wed, 01 July 2015 08:57
By: Michel Cadot
  REGEXP_REPLACE DISTINCT Mixed results
ORACLE 11
By: skyschrei on Tue, 23 June 2015
14 1266 Wed, 01 July 2015 04:56
By: mnitu
  Optimize PL/SQL code and get rid of one by one If then else statement check
Oracle 11g
By: raman.virk on Mon, 29 June 2015
6 443 Tue, 30 June 2015 02:48
By: pablolee
  is there any way to convert number into integer?
oracle 11g
By: mvrkr44 on Tue, 30 June 2015
16 425 Tue, 30 June 2015 02:14
By: Roachcoach
  Trigger on table to update other table
APEX, Oracle 10g
By: luijk008 on Sun, 28 June 2015
4 405 Mon, 29 June 2015 14:03
By: Bill B
  Execute a sql script depending on number of records in a table
11.2.0.4 on Linux
By: orausern on Mon, 29 June 2015
8 292 Mon, 29 June 2015 11:12
By: orausern
  Oracle Table last access detail
Oracle 11g
By: ashish.tiwari on Fri, 26 June 2015
5 389 Sun, 28 June 2015 00:27
By: Lalit Kumar B
  default value on update in oracle 11G
Oracle 11G , Windows 7
By: live4learn on Thu, 25 June 2015
2 1229 Fri, 26 June 2015 10:22
By: Bill B
  Date format help
oracle 11g
By: gorants on Thu, 25 June 2015
3 288 Fri, 26 June 2015 06:56
By: EdStevens
  Update Join..
Oracle 11.2.0.4/Windows 64 bit
By: sant_new1 on Thu, 25 June 2015
4 274 Thu, 25 June 2015 10:23
By: sant_new1
  pl/sql statement ignored
By: raja_rani on Wed, 24 June 2015
9 397 Thu, 25 June 2015 03:20
By: cookiemonster
  Compressing the partitions
11.2..0.4
By: varunvir on Thu, 18 June 2015
8 644 Wed, 24 June 2015 06:44
By: Roachcoach
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 Jul 30 06:03:38 CDT 2015

Total time taken to generate the page: 0.06131 seconds