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
  Creating String
Oracle 11g
By: Xandot on Fri, 31 July 2015
21 1445 Thu, 20 August 2015 04:16
By: Lalit Kumar B
  PL/SQL: ORA-00911: invalid character
Oracle 10g
By: thiruvari on Sat, 18 July 2015
5 1086 Thu, 20 August 2015 03:06
By: Michel Cadot
  Merge String
Oracle 11g
By: Xandot on Thu, 20 August 2015
4 520 Thu, 20 August 2015 02:12
By: Lalit Kumar B
  How to implement Materialized view in PL/SQL using Collections
Oracle Database 11g Release 11.2.0.3.0 - Production PL/SQL Release 11.2.0.3.0 - Production "CORE 11.2.0.3.0 Production" TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3
By: Lingaraju H C on Wed, 19 August 2015
10 657 Wed, 19 August 2015 21:42
By: John Watson
  check the column is numeric or data
oracle 9i
By: arun888 on Mon, 10 August 2015
35 1710 Wed, 19 August 2015 08:23
By: Bill B
icon7.gif Challenging Query
Oracle 11g , Windows 8
By: rakeshramm on Tue, 18 August 2015
5 564 Tue, 18 August 2015 06:44
By: Michel Cadot
  Hierarchy flattening and repetition
By: loosecontrol on Tue, 18 August 2015
3 407 Tue, 18 August 2015 05:23
By: Michel Cadot
  Exact String Match in Instr
Oracle 11g
By: Xandot on Sun, 16 August 2015
21 1101 Tue, 18 August 2015 00:30
By: Michel Cadot
  Need a Stored Procedure ( 1 2 3)
By: vasudevaviswa on Wed, 05 August 2015
86 4043 Mon, 17 August 2015 11:07
By: vasudevaviswa
  Need a Query to transpose rows to columns dynamically
By: yashaswini.gopalan on Wed, 12 August 2015
20 1405 Mon, 17 August 2015 01:26
By: Michel Cadot
  Need a Help on SQL query
By: ajay696 on Fri, 14 August 2015
7 648 Sat, 15 August 2015 09:37
By: EdStevens
  LEFT & Right functions to carve out data from a field
By: Johnseito on Tue, 11 August 2015
15 924 Fri, 14 August 2015 15:17
By: Bill B
  rownum and order by
Oracle 12
By: mats-larsson@iname.com on Thu, 13 August 2015
5 657 Fri, 14 August 2015 10:24
By: Michel Cadot
  Execute stored procedure after interval
Oracle 11g
By: christian.delbianco on Fri, 14 August 2015
1 444 Fri, 14 August 2015 02:43
By: Michel Cadot
icon5.gif "Merge" Values in one field with case?
Oracle 11.2 on Windows 2008R2
By: forumwurm on Thu, 13 August 2015
9 574 Thu, 13 August 2015 07:36
By: cookiemonster
  insert incremented value
plsql
By: sanodani on Thu, 13 August 2015
4 501 Thu, 13 August 2015 06:34
By: sanodani
  Cursor Query help
Oracle
By: GeetikaLearn on Mon, 10 August 2015
6 733 Wed, 12 August 2015 12:24
By: GeetikaLearn
  SQL join
By: sanodani on Tue, 11 August 2015
5 544 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 493 Tue, 11 August 2015 10:04
By: Michel Cadot
  union
sql
By: palpali on Tue, 11 August 2015
5 446 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 358 Mon, 10 August 2015 13:56
By: pablolee
  Need PL/SQL Script
12.1.3
By: vharish006 on Mon, 10 August 2015
5 420 Mon, 10 August 2015 13:56
By: vharish006
  calulating target and actual hrs
sql
By: palpali on Tue, 04 August 2015
16 859 Mon, 10 August 2015 00:32
By: palpali
  How to get value of table
oracle 11g
By: realbassist on Thu, 06 August 2015
18 1147 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 448 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 469 Thu, 06 August 2015 19:09
By: namitanamburi
  Update multiple columns in Case
Oracle 11g
By: Xandot on Thu, 06 August 2015
2 496 Thu, 06 August 2015 11:39
By: cookiemonster
  Convert rows into columns
oracle 10g
By: nciteamo on Thu, 06 August 2015
2 515 Thu, 06 August 2015 05:27
By: nciteamo
  Merge on tables
11.2.0.3
By: vasudevaviswa on Tue, 04 August 2015
13 610 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 841 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 1538 Wed, 05 August 2015 09:14
By: Bill B
  sql replacement price
11gr2
By: hudo on Wed, 05 August 2015
5 472 Wed, 05 August 2015 06:24
By: hudo
  only show the duplicated records
By: ajen7118 on Tue, 04 August 2015
4 508 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 463 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 666 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 1047 Mon, 03 August 2015 12:38
By: freestyle
  SQL Query
Oracle 11g
By: kr1347 on Sun, 02 August 2015
9 707 Mon, 03 August 2015 09:32
By: bugfox
  problem in record type
oracle 11g
By: somu1984 on Tue, 28 July 2015
6 834 Fri, 31 July 2015 08:36
By: Lalit Kumar B
  Joining Two View
Oracle 11G
By: samyms on Thu, 30 July 2015
19 1066 Fri, 31 July 2015 07:15
By: cookiemonster
  Union Join
By: ajen7118 on Thu, 30 July 2015
3 523 Fri, 31 July 2015 02:55
By: cookiemonster
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 Apr 29 07:28:31 CDT 2016

Total time taken to generate the page: 0.25813 seconds