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
  update century in timestamp column in table (topics merged)
oracle 10g
By: kadhirvel.k on Sat, 01 August 2015
24 1426 Wed, 05 August 2015 09:14
By: Bill B
  sql replacement price
11gr2
By: hudo on Wed, 05 August 2015
5 421 Wed, 05 August 2015 06:24
By: hudo
  only show the duplicated records
By: ajen7118 on Tue, 04 August 2015
4 456 Tue, 04 August 2015 15:53
By: BlackSwan
  Create a temporary/transient table within a SELECT
Oracle Enterprise 11g 11.2.0.4.0
By: johnjacobt on Tue, 04 August 2015
3 409 Tue, 04 August 2015 06:17
By: Michel Cadot
  Generating group of sets from table
10g
By: m.abdulhaq on Sun, 02 August 2015
8 604 Mon, 03 August 2015 13:55
By: m.abdulhaq
  Update table procedure through pl sql using double loop
Oracle
By: freestyle on Wed, 29 July 2015
11 967 Mon, 03 August 2015 12:38
By: freestyle
  SQL Query
Oracle 11g
By: kr1347 on Sun, 02 August 2015
9 638 Mon, 03 August 2015 09:32
By: bugfox
  problem in record type
oracle 11g
By: somu1984 on Tue, 28 July 2015
6 769 Fri, 31 July 2015 08:36
By: Lalit Kumar B
  Joining Two View
Oracle 11G
By: samyms on Thu, 30 July 2015
19 1002 Fri, 31 July 2015 07:15
By: cookiemonster
  Union Join
By: ajen7118 on Thu, 30 July 2015
3 465 Fri, 31 July 2015 02:55
By: cookiemonster
  i want to find the string 'EMP1' which procedures have that string under the package
oracle 11
By: eswararaodba@gmail.com on Thu, 30 July 2015
3 402 Fri, 31 July 2015 02:51
By: cookiemonster
  Time period condition
By: patneel on Thu, 30 July 2015
8 541 Fri, 31 July 2015 01:29
By: Michel Cadot
  Include if else in sql statement
By: hypesslearner on Mon, 20 July 2015
22 902 Thu, 30 July 2015 16:07
By: Bill B
  NUMERIC DENOMINATION
SQL NAV 6
By: rukku2015 on Sun, 26 July 2015
2 524 Thu, 30 July 2015 08:12
By: Solomon Yakobson
  Need a query to get the ouput in an expected format
By: nyaduguru on Wed, 29 July 2015
5 508 Thu, 30 July 2015 02:11
By: Lalit Kumar B
  Joining
By: Nasir.azeem on Wed, 29 July 2015
3 450 Wed, 29 July 2015 09:40
By: LKBrwn_DBA
  Max on Sum
By: zoe2003 on Mon, 20 April 2015
18 1358 Wed, 29 July 2015 02:45
By: cookiemonster
  concatenate the values in the o/p
By: mist598 on Mon, 27 July 2015
13 669 Mon, 27 July 2015 06:09
By: Lalit Kumar B
  query taking lot of time to execute
ORACLE 11g
By: manoj12 on Mon, 20 July 2015
18 2947 Mon, 27 July 2015 05:42
By: pablolee
  Update to_char(date,'YYYY')
oracle 10g
By: nciteamo on Sun, 26 July 2015
3 466 Mon, 27 July 2015 02:06
By: nciteamo
  Split column to rows in Oracle Sql
By: vspn on Wed, 22 July 2015
10 1094 Mon, 27 July 2015 01:25
By: Michel Cadot
  History Tables Search Criteria
windows
By: oraranjangmailcom on Thu, 23 July 2015
7 575 Mon, 27 July 2015 00:19
By: Michel Cadot
  NoSQL vs. Oracle
Oracle 11g xe
By: Eric Langager on Sun, 26 July 2015
2 615 Sun, 26 July 2015 11:56
By: Michel Cadot
  ORA-01732: data manipulation operation not legal on this view
By: Ashu_26 on Sun, 26 July 2015
6 718 Sun, 26 July 2015 02:48
By: Michel Cadot
  Rewriting a sql with NOT to avoid the NOT and OR clause
Oracle 11.2.0.5
By: orausern on Sat, 25 July 2015
3 522 Sat, 25 July 2015 14:27
By: Michel Cadot
  Transpose columns
Oracle 11g
By: rohit_shinez on Thu, 23 July 2015
1 711 Fri, 24 July 2015 10:40
By: LKBrwn_DBA
  SUM & Cursor
Oracle Database 11.2.0.1; Centos
By: nqtrung on Fri, 24 July 2015
4 387 Fri, 24 July 2015 01:57
By: nqtrung
  how to trapping error in SQL using SYS.DBMS_XMLGEN
oracle 11g redhat
By: Freewilly3d on Thu, 23 July 2015
4 387 Thu, 23 July 2015 10:55
By: Lalit Kumar B
  how to clear the output data using utl_file?
By: mist598 on Tue, 21 July 2015
12 661 Thu, 23 July 2015 05:43
By: mist598
  Like in Order by
Oracle 11g
By: Xandot on Tue, 21 July 2015
7 403 Wed, 22 July 2015 13:59
By: Bill B
  Covert unique string to unique number
Oracle 10
By: brown_zzz on Wed, 22 July 2015
4 335 Wed, 22 July 2015 12:42
By: John Watson
  Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error.
Oracle 11g : bug
By: victoryhendry on Tue, 21 July 2015
5 426 Wed, 22 July 2015 05:01
By: gazzag
  all_scheduler_job_run_details session_id column
Oracle 11g
By: dag1ngapr1nce on Tue, 21 July 2015
15 465 Tue, 21 July 2015 09:27
By: dag1ngapr1nce
  German Character Set
Oracle 11.2.0.1, RHEL
By: suddhasatwa_oracle on Tue, 21 July 2015
2 325 Tue, 21 July 2015 08:26
By: mnitu
  Creating SQL String
Oracle 11g
By: Xandot on Mon, 20 July 2015
8 498 Tue, 21 July 2015 07:52
By: Michel Cadot
  Issue with Number Conversion !!
Oracle 11.2.0.1, RHEL
By: suddhasatwa_oracle on Mon, 06 July 2015
5 520 Tue, 21 July 2015 04:02
By: suddhasatwa_oracle
  Bulk collect limit on what basis we will keep
By: sasank54 on Mon, 20 July 2015
2 377 Tue, 21 July 2015 02:06
By: Michel Cadot
  linking gv$sql and gv$session
11g
By: dag1ngapr1nce on Thu, 16 July 2015
14 787 Mon, 20 July 2015 08:46
By: dag1ngapr1nce
  Error with Delete Trigger
Oracle
By: mattfriend on Sun, 19 July 2015
7 536 Mon, 20 July 2015 07:29
By: mattfriend
  How to Split the Records
Oracle 10g
By: rahulsf on Mon, 20 July 2015
3 352 Mon, 20 July 2015 04:53
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: Sat Feb 06 07:47:46 CST 2016

Total time taken to generate the page: 0.10436 seconds