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
icon3.gif help with pattern match REGEXP etc
Oracle 11, 12
By: namitanamburi on Wed, 05 August 2015
4 480 Thu, 06 August 2015 19:09
By: namitanamburi
  Update multiple columns in Case
Oracle 11g
By: Xandot on Thu, 06 August 2015
2 517 Thu, 06 August 2015 11:39
By: cookiemonster
  Convert rows into columns
oracle 10g
By: nciteamo on Thu, 06 August 2015
2 528 Thu, 06 August 2015 05:27
By: nciteamo
  Merge on tables
11.2.0.3
By: vasudevaviswa on Tue, 04 August 2015
13 631 Wed, 05 August 2015 14:28
By: vasudevaviswa
  Need modification in Stored Procedure.
11.2.0.3
By: vasudevaviswa on Tue, 04 August 2015
19 871 Wed, 05 August 2015 10:26
By: Michel Cadot
  update century in timestamp column in table (topics merged)
oracle 10g
By: kadhirvel.k on Sat, 01 August 2015
24 1572 Wed, 05 August 2015 09:14
By: Bill B
  sql replacement price
11gr2
By: hudo on Wed, 05 August 2015
5 486 Wed, 05 August 2015 06:24
By: hudo
  only show the duplicated records
By: ajen7118 on Tue, 04 August 2015
4 532 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 483 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 682 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 1072 Mon, 03 August 2015 12:38
By: freestyle
  SQL Query
Oracle 11g
By: kr1347 on Sun, 02 August 2015
9 737 Mon, 03 August 2015 09:32
By: bugfox
  problem in record type
oracle 11g
By: somu1984 on Tue, 28 July 2015
6 851 Fri, 31 July 2015 08:36
By: Lalit Kumar B
  Joining Two View
Oracle 11G
By: samyms on Thu, 30 July 2015
19 1092 Fri, 31 July 2015 07:15
By: cookiemonster
  Union Join
By: ajen7118 on Thu, 30 July 2015
3 537 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 460 Fri, 31 July 2015 02:51
By: cookiemonster
  Time period condition
By: patneel on Thu, 30 July 2015
8 608 Fri, 31 July 2015 01:29
By: Michel Cadot
  Include if else in sql statement
By: hypesslearner on Mon, 20 July 2015
22 992 Thu, 30 July 2015 16:07
By: Bill B
  NUMERIC DENOMINATION
SQL NAV 6
By: rukku2015 on Sun, 26 July 2015
2 573 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 586 Thu, 30 July 2015 02:11
By: Lalit Kumar B
  Joining
By: Nasir.azeem on Wed, 29 July 2015
3 527 Wed, 29 July 2015 09:40
By: LKBrwn_DBA
  Max on Sum
By: zoe2003 on Mon, 20 April 2015
18 1459 Wed, 29 July 2015 02:45
By: cookiemonster
  concatenate the values in the o/p
By: mist598 on Mon, 27 July 2015
13 760 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 3054 Mon, 27 July 2015 05:42
By: pablolee
  Update to_char(date,'YYYY')
oracle 10g
By: nciteamo on Sun, 26 July 2015
3 635 Mon, 27 July 2015 02:06
By: nciteamo
  Split column to rows in Oracle Sql
By: vspn on Wed, 22 July 2015
10 1601 Mon, 27 July 2015 01:25
By: Michel Cadot
  History Tables Search Criteria
windows
By: oraranjangmailcom on Thu, 23 July 2015
7 647 Mon, 27 July 2015 00:19
By: Michel Cadot
  NoSQL vs. Oracle
Oracle 11g xe
By: Eric Langager on Sun, 26 July 2015
2 700 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 912 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 601 Sat, 25 July 2015 14:27
By: Michel Cadot
  Transpose columns
Oracle 11g
By: rohit_shinez on Thu, 23 July 2015
1 810 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 460 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 480 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 751 Thu, 23 July 2015 05:43
By: mist598
  Like in Order by
Oracle 11g
By: Xandot on Tue, 21 July 2015
7 476 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 398 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 518 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 573 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 400 Tue, 21 July 2015 08:26
By: mnitu
  Creating SQL String
Oracle 11g
By: Xandot on Mon, 20 July 2015
8 581 Tue, 21 July 2015 07:52
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: Tue May 24 01:44:25 CDT 2016

Total time taken to generate the page: 0.09378 seconds