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
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 18 Mon, 05 September 2011 02:20
By: Littlefoot
  Maxl Script for Outline Editting
Oracle Essbase, general, windows
By: pumelayurika on Sun, 05 July 2015
0 31 Sun, 05 July 2015 21:36
By: pumelayurika
  Last four weeks data
Oracle 12c
By: imranhemani on Sun, 05 July 2015
1 52 Sun, 05 July 2015 18:42
By: BlackSwan
  need select query based on pl sql table
oracle 11g
By: mvrkr44 on Mon, 29 June 2015
2 242 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 529 Sun, 05 July 2015 00:45
By: Kevin Meade
  want to delete 42k duplicate rows from table 18 mill rows
10g
By: cplusplus1 on Wed, 01 July 2015
18 710 Sun, 05 July 2015 00:32
By: Kevin Meade
  Oracle SQL Customization
Oracle 12C
By: deepakdot on Sat, 04 July 2015
4 338 Sat, 04 July 2015 05:06
By: Littlefoot
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 48605 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 705 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 1215 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 287 Wed, 01 July 2015 08:57
By: Michel Cadot
  REGEXP_REPLACE DISTINCT Mixed results
ORACLE 11
By: skyschrei on Tue, 23 June 2015
14 1207 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 377 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 357 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 330 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 230 Mon, 29 June 2015 11:12
By: orausern
  Oracle Table last access detail
Oracle 11g
By: ashish.tiwari on Fri, 26 June 2015
5 321 Sun, 28 June 2015 00:27
By: Lalit Kumar B
  copy one table to another table
hp unix
By: arun888 on Fri, 12 June 2015
27 1494 Fri, 26 June 2015 11:26
By: Littlefoot
  default value on update in oracle 11G
Oracle 11G , Windows 7
By: live4learn on Thu, 25 June 2015
2 1184 Fri, 26 June 2015 10:22
By: Bill B
  Date format help
oracle 11g
By: gorants on Thu, 25 June 2015
3 239 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 223 Thu, 25 June 2015 10:23
By: sant_new1
  pl/sql statement ignored
By: raja_rani on Wed, 24 June 2015
9 352 Thu, 25 June 2015 03:20
By: cookiemonster
  Compressing the partitions
11.2..0.4
By: varunvir on Thu, 18 June 2015
8 615 Wed, 24 June 2015 06:44
By: Roachcoach
  Update a column in table only if a condition is met for number of values for a field in other table
By: suhaas on Fri, 19 June 2015
10 687 Tue, 23 June 2015 13:33
By: Bill B
icon5.gif Substitute variable in script
oracle 11g r2
By: ajaapba on Mon, 22 June 2015
7 489 Tue, 23 June 2015 09:20
By: gazzag
  Date Parameter Issue
By: dilip.nnitw@gmail.com on Mon, 22 June 2015
3 496 Tue, 23 June 2015 04:13
By: dilip.nnitw@gmail.com
  Design to Validate Staging records (merged)
ORACLE 11g
By: jagadeesh.nraj on Mon, 15 June 2015
10 711 Mon, 22 June 2015 13:39
By: ravikanth_b
  SQL Query Case and Count
Oracle
By: elements92 on Fri, 19 June 2015
6 433 Mon, 22 June 2015 05:11
By: cookiemonster
  date format from string
Oracle 11g
By: mape on Fri, 19 June 2015
16 523 Mon, 22 June 2015 04:22
By: cookiemonster
  require output in described order
oracle 11g
By: jgjeetu on Sun, 21 June 2015
3 265 Sun, 21 June 2015 08:37
By: jgjeetu
  Managing the backup tables
Oracle, 11g
By: scorpy90 on Sat, 20 June 2015
2 310 Sat, 20 June 2015 14:16
By: John Watson
  Generate Start - End date
11.2
By: lott42 on Fri, 19 June 2015
2 298 Fri, 19 June 2015 13:42
By: lott42
  'Free text' select statment
Oracle 4.0.2.15.21
By: SteveShephard on Fri, 19 June 2015
2 280 Fri, 19 June 2015 06:54
By: Michel Cadot
  Split rows into columns
4.0.2.15.21
By: SteveShephard on Fri, 19 June 2015
3 286 Fri, 19 June 2015 06:52
By: Michel Cadot
  Cross tab SQL query
Oracle 9i
By: tarasasu on Mon, 15 June 2015
13 681 Fri, 19 June 2015 03:23
By: pablolee
  Function declartation
oracle 10g
By: arun888 on Fri, 19 June 2015
3 231 Fri, 19 June 2015 02:40
By: arun888
  dynamic input value passing
ORACLE 10G
By: arun888 on Thu, 18 June 2015
3 241 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 539 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 766 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 493 Tue, 16 June 2015 07:20
By: wtolentino
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: Sun Jul 05 22:22:46 CDT 2015

Total time taken to generate the page: 0.11920 seconds