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 1760 Wed, 05 August 2015 09:14
By: Bill B
  sql replacement price
11gr2
By: hudo on Wed, 05 August 2015
5 540 Wed, 05 August 2015 06:24
By: hudo
  only show the duplicated records
By: ajen7118 on Tue, 04 August 2015
4 616 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 553 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 767 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 1164 Mon, 03 August 2015 12:38
By: freestyle
  SQL Query
Oracle 11g
By: kr1347 on Sun, 02 August 2015
9 829 Mon, 03 August 2015 09:32
By: bugfox
  problem in record type
oracle 11g
By: somu1984 on Tue, 28 July 2015
6 911 Fri, 31 July 2015 08:36
By: Lalit Kumar B
  Joining Two View
Oracle 11G
By: samyms on Thu, 30 July 2015
19 1171 Fri, 31 July 2015 07:15
By: cookiemonster
  Union Join
By: ajen7118 on Thu, 30 July 2015
3 601 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 517 Fri, 31 July 2015 02:51
By: cookiemonster
  Time period condition
By: patneel on Thu, 30 July 2015
8 696 Fri, 31 July 2015 01:29
By: Michel Cadot
  Include if else in sql statement
By: hypesslearner on Mon, 20 July 2015
22 1067 Thu, 30 July 2015 16:07
By: Bill B
  NUMERIC DENOMINATION
SQL NAV 6
By: rukku2015 on Sun, 26 July 2015
2 611 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 644 Thu, 30 July 2015 02:11
By: Lalit Kumar B
  Joining
By: Nasir.azeem on Wed, 29 July 2015
3 573 Wed, 29 July 2015 09:40
By: LKBrwn_DBA
  Max on Sum
By: zoe2003 on Mon, 20 April 2015
18 1542 Wed, 29 July 2015 02:45
By: cookiemonster
  concatenate the values in the o/p
By: mist598 on Mon, 27 July 2015
13 832 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 3128 Mon, 27 July 2015 05:42
By: pablolee
  Update to_char(date,'YYYY')
oracle 10g
By: nciteamo on Sun, 26 July 2015
3 886 Mon, 27 July 2015 02:06
By: nciteamo
  Split column to rows in Oracle Sql
By: vspn on Wed, 22 July 2015
10 2062 Mon, 27 July 2015 01:25
By: Michel Cadot
  History Tables Search Criteria
windows
By: oraranjangmailcom on Thu, 23 July 2015
7 695 Mon, 27 July 2015 00:19
By: Michel Cadot
  NoSQL vs. Oracle
Oracle 11g xe
By: Eric Langager on Sun, 26 July 2015
2 754 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 1177 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 650 Sat, 25 July 2015 14:27
By: Michel Cadot
  Transpose columns
Oracle 11g
By: rohit_shinez on Thu, 23 July 2015
1 890 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 517 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 537 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 828 Thu, 23 July 2015 05:43
By: mist598
  Like in Order by
Oracle 11g
By: Xandot on Tue, 21 July 2015
7 528 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 454 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 578 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 677 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 450 Tue, 21 July 2015 08:26
By: mnitu
  Creating SQL String
Oracle 11g
By: Xandot on Mon, 20 July 2015
8 642 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 689 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 458 Tue, 21 July 2015 02:06
By: Michel Cadot
  linking gv$sql and gv$session
11g
By: dag1ngapr1nce on Thu, 16 July 2015
14 1112 Mon, 20 July 2015 08:46
By: dag1ngapr1nce
  Error with Delete Trigger
Oracle
By: mattfriend on Sun, 19 July 2015
7 707 Mon, 20 July 2015 07:29
By: mattfriend
  How to Split the Records
Oracle 10g
By: rahulsf on Mon, 20 July 2015
3 449 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: Fri Sep 30 22:25:26 CDT 2016

Total time taken to generate the page: 0.07480 seconds