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
  Sort data output to excel (owa_util) from 2 cursor
By: aryanna on Wed, 05 March 2014
1 135 Wed, 05 March 2014 20:52
By: BlackSwan
  PlSql open read cell in excel file!!
Forms [32 Bit] Version 9.0.2.9.0 , oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), window , IE 8
By: meteo on Wed, 05 March 2014
8 483 Wed, 05 March 2014 15:14
By: meteo
  SDO_GTYPE count and group by based on tables in all_tab_cols?
By: psnepvangers on Tue, 04 March 2014
4 296 Wed, 05 March 2014 04:06
By: Michel Cadot
  Wrong result in trying to find offset change time
Oracle 11.2.0.3.0 on OEL 5.7 to Oracle 11.2.0.1.0 OEL 5.7
By: Andrey_R on Tue, 04 March 2014
4 249 Wed, 05 March 2014 04:01
By: Andrey_R
  cursor_sharing force 11g r2
oracle 11g / 11gr2/unix
By: balaji123 on Wed, 05 March 2014
4 167 Wed, 05 March 2014 02:22
By: Michel Cadot
  Dynamic Column Generation
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 04 March 2014
4 433 Tue, 04 March 2014 09:21
By: Solomon Yakobson
  Columns values into rows
By: msinha8 on Tue, 04 March 2014
4 394 Tue, 04 March 2014 05:52
By: Michel Cadot
  Locked Stats
11
By: blackpanther on Mon, 03 March 2014
2 232 Tue, 04 March 2014 02:33
By: Roachcoach
  dbms_output.put_line
oracle11g/r2/unix
By: balaji123 on Tue, 04 March 2014
2 278 Tue, 04 March 2014 02:09
By: John Watson
  Rollup using with UNION
By: zsiddiquis on Mon, 03 March 2014
6 440 Mon, 03 March 2014 12:01
By: Michel Cadot
  Index on column name "number"!!!
By: vulcanjibe on Fri, 28 February 2014
7 667 Sat, 01 March 2014 11:29
By: vulcanjibe
icon4.gif SQL - QUERY
By: vippysharma on Fri, 28 February 2014
8 732 Sat, 01 March 2014 09:53
By: Michel Cadot
  Get previous quarter value
By: Bluebeam on Fri, 28 February 2014
1 163 Fri, 28 February 2014 18:56
By: BlackSwan
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
6 498 Fri, 28 February 2014 11:05
By: Michel Cadot
  SQL code to retrieve items in consective periods
using TOAD for Oracle
By: markw1906 on Fri, 28 February 2014
1 170 Fri, 28 February 2014 09:59
By: BlackSwan
  sql execution
oracle 11g/r2 unix
By: balaji123 on Fri, 28 February 2014
3 204 Fri, 28 February 2014 03:37
By: Roachcoach
  PIVOT - SQL Command not properly ended
TOAD 10.6
By: kupstar on Thu, 27 February 2014
13 406 Fri, 28 February 2014 02:53
By: cookiemonster
  Open Cursor for with an Exception Clause
11g Release 2 Windows
By: Duane on Thu, 27 February 2014
21 901 Thu, 27 February 2014 18:39
By: Duane
icon14.gif Get Min Value Where It Is Not Null ( 1 2)
By: aimy on Mon, 10 February 2014
45 2313 Thu, 27 February 2014 18:36
By: aimy
  Need help to build xml tag in oracle sql queries
oracle 10g
By: spatava on Thu, 27 February 2014
6 365 Thu, 27 February 2014 07:18
By: Solomon Yakobson
  DDL and DML
By: deepak439 on Wed, 26 February 2014
2 204 Thu, 27 February 2014 00:46
By: Michel Cadot
  Need invalid records
PL/SQL Release 11.2.0.2.0 ,Win 7 Professional
By: shumail on Sun, 23 February 2014
4 410 Wed, 26 February 2014 22:26
By: ken002
  how to make it by help of procedure
By: aaditya321 on Wed, 26 February 2014
3 355 Wed, 26 February 2014 01:21
By: Michel Cadot
  CLOB extraction
Oracle 11g
By: OraFaq13 on Tue, 25 February 2014
5 343 Tue, 25 February 2014 17:23
By: BlackSwan
  Query for the below
By: ramraju20000 on Tue, 25 February 2014
1 178 Tue, 25 February 2014 10:50
By: Michel Cadot
  Column Restriction
Oracle 11g
By: ORAGENASHOK on Tue, 25 February 2014
6 446 Tue, 25 February 2014 09:33
By: BlackSwan
  Putting a WITH statement into PL/SQL
Oracle 11g
By: skbytes on Tue, 25 February 2014
6 484 Tue, 25 February 2014 05:08
By: skbytes
  clob aggregation (merged)
By: rajivn786 on Fri, 09 July 2010
35 2142 Tue, 25 February 2014 02:36
By: subrat_pinku
  Date Typecast Usage
Oracle Database 11g
By: manubatham20 on Mon, 24 February 2014
7 469 Mon, 24 February 2014 21:00
By: BlackSwan
  When I joining char and varchar2 column, I am not getting now rows
Oralce 11g
By: na.dharma@gmail.com on Mon, 24 February 2014
7 459 Mon, 24 February 2014 10:42
By: Solomon Yakobson
  Employee(s) Getting Less Than the Average Salary
Oracle 10g
By: sonudev on Wed, 19 February 2014
13 673 Mon, 24 February 2014 08:58
By: cookiemonster
  Split a varchar variable
11.2.0.3.0
By: Amine on Sun, 23 February 2014
9 666 Sun, 23 February 2014 15:29
By: Amine
  Need to get records equal to the number of month days.
Oracle Database 10g Rel.2
By: mazam on Fri, 21 February 2014
8 683 Sat, 22 February 2014 00:18
By: Michel Cadot
icon2.gif Performance impact by using Number/Char column as primary key
11g, AIX
By: harpreetsinghkup on Fri, 21 February 2014
4 236 Fri, 21 February 2014 20:02
By: Kevin Meade
  Perform minus operation between two Pl/SQL Record Type Tables
By: ady_koolz on Fri, 21 February 2014
9 448 Fri, 21 February 2014 15:54
By: DrabJay
  Query to find different league matches between team, no repeatitive league matches (only once)
Oracle 11g R1 Linux
By: anil_mk on Fri, 21 February 2014
4 351 Fri, 21 February 2014 08:12
By: msol25
  Need to put results of SQL into a table
Oracle SQL
By: skbytes on Fri, 21 February 2014
3 421 Fri, 21 February 2014 05:06
By: skbytes
  Oracle Partitioning
Oracle 10 G, Windows 7
By: s4.ora on Fri, 21 February 2014
3 290 Fri, 21 February 2014 03:22
By: Michel Cadot
  Multiple Output values in a dynamic sql
10.2.0.4, Windows
By: sandba00 on Thu, 20 February 2014
7 470 Fri, 21 February 2014 03:11
By: Michel Cadot
  Retrieve Data from a Table based on OR condition
Oracle 11G, Sun Solaris
By: ady_koolz on Tue, 11 February 2014
5 321 Fri, 21 February 2014 01:18
By: ady_koolz
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: Sun Apr 20 10:09:22 CDT 2014

Total time taken to generate the page: 0.10961 seconds