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
  SQL join
By: sanodani on Tue, 11 August 2015
5 487 Wed, 12 August 2015 04:59
By: Lalit Kumar B
  Transpose of rows to Columns & Dynamically Adding the Columns (merged)
By: Harsha20 on Tue, 11 August 2015
2 456 Tue, 11 August 2015 10:04
By: Michel Cadot
  union
sql
By: palpali on Tue, 11 August 2015
5 408 Tue, 11 August 2015 07:06
By: pablolee
  Oracle analytic query help
Oracle 10g R10.0.2
By: parmarjm on Mon, 10 August 2015
3 311 Mon, 10 August 2015 13:56
By: pablolee
  Need PL/SQL Script
12.1.3
By: vharish006 on Mon, 10 August 2015
5 368 Mon, 10 August 2015 13:56
By: vharish006
  calulating target and actual hrs
sql
By: palpali on Tue, 04 August 2015
16 812 Mon, 10 August 2015 00:32
By: palpali
  How to get value of table
oracle 11g
By: realbassist on Thu, 06 August 2015
18 1052 Fri, 07 August 2015 04:02
By: Lalit Kumar B
  Filtering data by aggregated columns calculated in a subquery.
By: mcrum1 on Thu, 06 August 2015
2 393 Fri, 07 August 2015 01:21
By: Littlefoot
icon3.gif help with pattern match REGEXP etc
Oracle 11, 12
By: namitanamburi on Wed, 05 August 2015
4 425 Thu, 06 August 2015 19:09
By: namitanamburi
  Update multiple columns in Case
Oracle 11g
By: Xandot on Thu, 06 August 2015
2 434 Thu, 06 August 2015 11:39
By: cookiemonster
  Convert rows into columns
oracle 10g
By: nciteamo on Thu, 06 August 2015
2 458 Thu, 06 August 2015 05:27
By: nciteamo
  Merge on tables
11.2.0.3
By: vasudevaviswa on Tue, 04 August 2015
13 556 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 777 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 1432 Wed, 05 August 2015 09:14
By: Bill B
  sql replacement price
11gr2
By: hudo on Wed, 05 August 2015
5 426 Wed, 05 August 2015 06:24
By: hudo
  only show the duplicated records
By: ajen7118 on Tue, 04 August 2015
4 460 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 410 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 607 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 970 Mon, 03 August 2015 12:38
By: freestyle
  SQL Query
Oracle 11g
By: kr1347 on Sun, 02 August 2015
9 645 Mon, 03 August 2015 09:32
By: bugfox
  problem in record type
oracle 11g
By: somu1984 on Tue, 28 July 2015
6 773 Fri, 31 July 2015 08:36
By: Lalit Kumar B
  Joining Two View
Oracle 11G
By: samyms on Thu, 30 July 2015
19 1013 Fri, 31 July 2015 07:15
By: cookiemonster
  Union Join
By: ajen7118 on Thu, 30 July 2015
3 474 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 409 Fri, 31 July 2015 02:51
By: cookiemonster
  Time period condition
By: patneel on Thu, 30 July 2015
8 549 Fri, 31 July 2015 01:29
By: Michel Cadot
  Include if else in sql statement
By: hypesslearner on Mon, 20 July 2015
22 910 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 516 Thu, 30 July 2015 02:11
By: Lalit Kumar B
  Joining
By: Nasir.azeem on Wed, 29 July 2015
3 453 Wed, 29 July 2015 09:40
By: LKBrwn_DBA
  Max on Sum
By: zoe2003 on Mon, 20 April 2015
18 1365 Wed, 29 July 2015 02:45
By: cookiemonster
  concatenate the values in the o/p
By: mist598 on Mon, 27 July 2015
13 671 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 2960 Mon, 27 July 2015 05:42
By: pablolee
  Update to_char(date,'YYYY')
oracle 10g
By: nciteamo on Sun, 26 July 2015
3 471 Mon, 27 July 2015 02:06
By: nciteamo
  Split column to rows in Oracle Sql
By: vspn on Wed, 22 July 2015
10 1108 Mon, 27 July 2015 01:25
By: Michel Cadot
  History Tables Search Criteria
windows
By: oraranjangmailcom on Thu, 23 July 2015
7 580 Mon, 27 July 2015 00:19
By: Michel Cadot
  NoSQL vs. Oracle
Oracle 11g xe
By: Eric Langager on Sun, 26 July 2015
2 622 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 723 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 523 Sat, 25 July 2015 14:27
By: Michel Cadot
  Transpose columns
Oracle 11g
By: rohit_shinez on Thu, 23 July 2015
1 713 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
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: Thu Feb 11 09:48:13 CST 2016

Total time taken to generate the page: 0.15534 seconds