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
  is there any way to convert number into integer?
oracle 11g
By: mvrkr44 on Tue, 30 June 2015
16 751 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 758 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 525 Mon, 29 June 2015 11:12
By: orausern
  Oracle Table last access detail
Oracle 11g
By: ashish.tiwari on Fri, 26 June 2015
5 757 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 1651 Fri, 26 June 2015 10:22
By: Bill B
  Date format help
oracle 11g
By: gorants on Thu, 25 June 2015
3 523 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 567 Thu, 25 June 2015 10:23
By: sant_new1
  pl/sql statement ignored
By: raja_rani on Wed, 24 June 2015
9 954 Thu, 25 June 2015 03:20
By: cookiemonster
  Compressing the partitions
11.2..0.4
By: varunvir on Thu, 18 June 2015
8 984 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 1004 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 762 Tue, 23 June 2015 09:20
By: gazzag
  Date Parameter Issue
By: dilip.nnitw@gmail.com on Mon, 22 June 2015
3 773 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 1095 Mon, 22 June 2015 13:39
By: ravikanth_b
  SQL Query Case and Count
Oracle
By: elements92 on Fri, 19 June 2015
6 845 Mon, 22 June 2015 05:11
By: cookiemonster
  date format from string
Oracle 11g
By: mape on Fri, 19 June 2015
16 887 Mon, 22 June 2015 04:22
By: cookiemonster
  require output in described order
oracle 11g
By: jgjeetu on Sun, 21 June 2015
3 473 Sun, 21 June 2015 08:37
By: jgjeetu
  Managing the backup tables
Oracle, 11g
By: scorpy90 on Sat, 20 June 2015
2 530 Sat, 20 June 2015 14:16
By: John Watson
  Generate Start - End date
11.2
By: lott42 on Fri, 19 June 2015
2 687 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 480 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 552 Fri, 19 June 2015 06:52
By: Michel Cadot
  Cross tab SQL query
Oracle 9i
By: tarasasu on Mon, 15 June 2015
13 1142 Fri, 19 June 2015 03:23
By: pablolee
  Function declartation
oracle 10g
By: arun888 on Fri, 19 June 2015
3 427 Fri, 19 June 2015 02:40
By: arun888
  dynamic input value passing
ORACLE 10G
By: arun888 on Thu, 18 June 2015
3 463 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 760 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 1136 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 838 Tue, 16 June 2015 07:20
By: wtolentino
  Sysdate with time interval parameter
Oracle 11i
By: RADHAKAN on Mon, 15 June 2015
16 1041 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 875 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 2179 Mon, 15 June 2015 03:02
By: pablolee
  Interview Question
oracle 11g
By: anniepeteroracle on Mon, 15 June 2015
4 632 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 1773 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 1316 Fri, 12 June 2015 06:09
By: bugfox
  Duplicate Data
Oracle 11g
By: plsql_guy on Sat, 23 May 2015
36 1960 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 665 Thu, 11 June 2015 08:08
By: cookiemonster
  Difference
9i
By: glmjoy on Wed, 10 June 2015
5 770 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 1091 Wed, 10 June 2015 00:54
By: Michel Cadot
  SQL query help
By: Developer9 on Mon, 08 June 2015
8 845 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 796 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 546 Tue, 09 June 2015 03:21
By: Michel Cadot
  ORA-30036 while running a Procedure
9i
By: Jaise on Mon, 08 June 2015
7 574 Mon, 08 June 2015 14:55
By: Michel Cadot
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 Aug 26 18:28:46 CDT 2016

Total time taken to generate the page: 0.11688 seconds