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
  Find the number 3 in the third and last digits of an SSN
oracle 11g
By: tuckersuz on Thu, 07 August 2014
5 365 Mon, 11 August 2014 16:53
By: tuckersuz
  Window Functions = Analytic Functions in Oracle RDBMS?
Oracle 11g
By: rc3d on Mon, 11 August 2014
10 419 Mon, 11 August 2014 15:39
By: Littlefoot
  number to date format ?
By: tondapi on Mon, 11 August 2014
12 749 Mon, 11 August 2014 13:25
By: Lalit Kumar B
  Testing for Numeric when a varchar is passed in
10.2
By: lott42 on Fri, 08 August 2014
7 832 Mon, 11 August 2014 11:50
By: lott42
  procedure with loop
oracle 11g
By: tuckersuz on Mon, 11 August 2014
6 299 Mon, 11 August 2014 09:32
By: Lalit Kumar B
  How can I get the distinct rows?
oracle
By: zhuyeq on Sun, 10 August 2014
4 402 Sun, 10 August 2014 22:14
By: zhuyeq
  list of invalid objects
11g
By: kiranrathodkr916 on Sat, 02 August 2014
30 1192 Fri, 08 August 2014 22:14
By: kiranrathodkr916
  Matching pattern with given word
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Thu, 07 August 2014
15 577 Fri, 08 August 2014 20:30
By: manubatham20
  how to use constant
By: mist598 on Thu, 07 August 2014
11 548 Fri, 08 August 2014 00:15
By: mist598
  Moving Data from one table to other base on records size.
11G
By: Yuvraaj on Wed, 06 August 2014
12 532 Thu, 07 August 2014 14:59
By: Yuvraaj
  Rollup function?
Oracle 11g
By: SteveShephard on Thu, 07 August 2014
5 345 Thu, 07 August 2014 10:29
By: Lalit Kumar B
  recursive triggers.
By: mist598 on Thu, 07 August 2014
12 430 Thu, 07 August 2014 07:32
By: Solomon Yakobson
  Creating MAT view - Long running
Oracle 11g
By: Oracle_Walker on Thu, 07 August 2014
2 264 Thu, 07 August 2014 02:30
By: Littlefoot
  numeric for loop
oracle 11g
By: tuckersuz on Wed, 06 August 2014
3 311 Wed, 06 August 2014 14:38
By: BlackSwan
  Several updates vs one update
Oracle, 11g, Linux
By: fixxxer on Tue, 05 August 2014
8 620 Wed, 06 August 2014 06:35
By: Kevin Meade
  re-write the query for better performance
10g
By: mohan1760 on Wed, 06 August 2014
6 395 Wed, 06 August 2014 04:20
By: cookiemonster
  How to make logic
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Mon, 04 August 2014
18 850 Tue, 05 August 2014 16:05
By: shumail
  Alter statement issue in PL/SQL block
oracle 10g
By: gorants on Mon, 04 August 2014
14 1216 Tue, 05 August 2014 15:15
By: Solomon Yakobson
  time slots of 1 hour within a fixed working hours
By: oraclehi on Tue, 05 August 2014
2 292 Tue, 05 August 2014 14:06
By: BlackSwan
  Schedule Job in Oracle - With conditions
Oracle 10.2.0.5
By: praveenramaswamy on Tue, 05 August 2014
3 298 Tue, 05 August 2014 11:53
By: Michel Cadot
  Sending an email Contain pie chart by PL/SQL
By: raul33 on Mon, 04 August 2014
3 384 Tue, 05 August 2014 09:45
By: Lalit Kumar B
  SQL
Oracle 11g
By: ORAGENASHOK on Mon, 04 August 2014
12 658 Tue, 05 August 2014 03:52
By: cookiemonster
icon4.gif Help Required: Parsing String Collection or Concatenated String
Oracle 11g
By: nickz on Sun, 03 August 2014
14 869 Mon, 04 August 2014 16:46
By: nickz
  PL sql block
oracle 11g
By: shaikhaltaf05@gmai.com on Wed, 30 July 2014
9 619 Mon, 04 August 2014 10:07
By: Lalit Kumar B
  SQL query combination
Oracle 11g SQL
By: skbytes on Mon, 04 August 2014
5 259 Mon, 04 August 2014 10:04
By: skbytes
  SQL
Oracle 11g
By: ORAGENASHOK on Thu, 31 July 2014
10 602 Mon, 04 August 2014 08:54
By: Lalit Kumar B
  how to get the total records using LEVEL
By: mist598 on Mon, 04 August 2014
10 371 Mon, 04 August 2014 07:35
By: mist598
  Avoid Exception
Oracle 11g,Win7 32 bit
By: Xandot on Mon, 04 August 2014
1 258 Mon, 04 August 2014 04:26
By: Michel Cadot
  How to sort within concatenated columns
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
By: rappaj on Thu, 31 July 2014
9 435 Sun, 03 August 2014 18:03
By: rappaj
  Dynamic Column Generation by using pivot
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 27 November 2012
5 2885 Sun, 03 August 2014 12:19
By: ShantveerS
icon14.gif Executing procedures in parallel
Any
By: km88 on Sun, 03 August 2014
3 301 Sun, 03 August 2014 10:29
By: Lalit Kumar B
  how to select data from subpartition table
oracle 10g
By: jgjeetu on Sat, 02 August 2014
3 836 Sat, 02 August 2014 02:23
By: jgjeetu
  case statemnent
By: mist598 on Fri, 01 August 2014
7 708 Sat, 02 August 2014 01:11
By: jpatel7
  Rights query
Oracle 10.2.0.3
By: pointers on Fri, 01 August 2014
9 614 Sat, 02 August 2014 00:46
By: pointers
  Exception Handling For %type , %Rowtype variables
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionE
By: saipradyumn on Fri, 01 August 2014
1 329 Fri, 01 August 2014 06:30
By: Solomon Yakobson
  How to write query for subpartition table
oracle 10g
By: jgjeetu on Fri, 01 August 2014
4 382 Fri, 01 August 2014 04:20
By: jgjeetu
  small question related to loading of table in database
oracle 10g
By: harry13 on Fri, 01 August 2014
5 315 Fri, 01 August 2014 04:16
By: Lalit Kumar B
  Update Query with Returning Clause
Oracle 12c
By: cklh2000 on Wed, 30 July 2014
14 638 Thu, 31 July 2014 15:17
By: Michel Cadot
  Production Query
Oracle 11g
By: madsen on Thu, 31 July 2014
8 580 Thu, 31 July 2014 15:07
By: madsen
  SQL query to retrieve one record for each employee
By: mist598 on Thu, 31 July 2014
15 661 Thu, 31 July 2014 15:02
By: Lalit Kumar B
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 Jan 30 08:15:52 CST 2015

Total time taken to generate the page: 0.11803 seconds