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
  how to remove redundant data
By: evivek on Thu, 06 March 2014
1 251 Thu, 06 March 2014 14:53
By: BlackSwan
  Varchar2 Length
By: OraFaq13 on Wed, 05 March 2014
3 337 Thu, 06 March 2014 11:46
By: OraFaq13
  Delete thousends of tables per script (without undo)
Unix, Oracle 9.x
By: forumwurm on Thu, 06 March 2014
16 1040 Thu, 06 March 2014 07:19
By: Solomon Yakobson
  Need to retrieve records by getting columns from all_tab_columns
By: HemaV on Thu, 06 March 2014
4 405 Thu, 06 March 2014 06:50
By: Michel Cadot
  Sending UTL_SMTP mail with jpg picture as header inside an e-mail
11.2.0.3.0
By: sivakumar121 on Mon, 07 October 2013
12 1675 Thu, 06 March 2014 04:35
By: vslabs
  ALL condition
Oracle 8.1.7.0.0, Windows 2004
By: kumarvk on Tue, 04 March 2014
15 750 Thu, 06 March 2014 01:55
By: kumarvk
  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 619 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 420 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 347 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 261 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 501 Tue, 04 March 2014 09:21
By: Solomon Yakobson
  Columns values into rows
By: msinha8 on Tue, 04 March 2014
4 480 Tue, 04 March 2014 05:52
By: Michel Cadot
  Locked Stats
11
By: blackpanther on Mon, 03 March 2014
2 283 Tue, 04 March 2014 02:33
By: Roachcoach
  dbms_output.put_line
oracle11g/r2/unix
By: balaji123 on Tue, 04 March 2014
2 327 Tue, 04 March 2014 02:09
By: John Watson
  Rollup using with UNION
By: zsiddiquis on Mon, 03 March 2014
6 532 Mon, 03 March 2014 12:01
By: Michel Cadot
  Index on column name "number"!!!
By: vulcanjibe on Fri, 28 February 2014
7 739 Sat, 01 March 2014 11:29
By: vulcanjibe
icon4.gif SQL - QUERY
By: vippysharma on Fri, 28 February 2014
8 833 Sat, 01 March 2014 09:53
By: Michel Cadot
  Get previous quarter value
By: Bluebeam on Fri, 28 February 2014
1 214 Fri, 28 February 2014 18:56
By: BlackSwan
  SQL code to retrieve items in consective periods
using TOAD for Oracle
By: markw1906 on Fri, 28 February 2014
1 261 Fri, 28 February 2014 09:59
By: BlackSwan
  sql execution
oracle 11g/r2 unix
By: balaji123 on Fri, 28 February 2014
3 251 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 536 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 976 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 2523 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 440 Thu, 27 February 2014 07:18
By: Solomon Yakobson
  DDL and DML
By: deepak439 on Wed, 26 February 2014
2 248 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 472 Wed, 26 February 2014 22:26
By: ken002
  how to make it by help of procedure
By: aaditya321 on Wed, 26 February 2014
3 400 Wed, 26 February 2014 01:21
By: Michel Cadot
  CLOB extraction
Oracle 11g
By: OraFaq13 on Tue, 25 February 2014
5 434 Tue, 25 February 2014 17:23
By: BlackSwan
  Query for the below
By: ramraju20000 on Tue, 25 February 2014
1 286 Tue, 25 February 2014 10:50
By: Michel Cadot
  Column Restriction
Oracle 11g
By: ORAGENASHOK on Tue, 25 February 2014
6 527 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 542 Tue, 25 February 2014 05:08
By: skbytes
  clob aggregation (merged)
By: rajivn786 on Fri, 09 July 2010
35 2344 Tue, 25 February 2014 02:36
By: subrat_pinku
  Date Typecast Usage
Oracle Database 11g
By: manubatham20 on Mon, 24 February 2014
7 550 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 564 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 734 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 770 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 784 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 324 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 563 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 457 Fri, 21 February 2014 08:12
By: msol25
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 Jul 29 12:09:47 CDT 2014

Total time taken to generate the page: 0.27837 seconds