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
  Retrieve All Columns With Specific Value
By: aimy on Mon, 10 March 2014
10 846 Thu, 13 March 2014 07:13
By: Solomon Yakobson
  ORA-01460: unimplemented or unreasonable conversion requested
Oracle 10g
By: sss111ind on Thu, 13 March 2014
14 876 Thu, 13 March 2014 06:43
By: mist598
  How to identify special character
Oracle 11g
By: na.dharma@gmail.com on Thu, 13 March 2014
1 265 Thu, 13 March 2014 06:04
By: Michel Cadot
  Oracle 11g R2
Red hat linux 6.4
By: oradba123 on Wed, 12 March 2014
4 388 Thu, 13 March 2014 04:07
By: Michel Cadot
  ANY,ALL Operators
By: mist598 on Thu, 13 March 2014
2 297 Thu, 13 March 2014 01:20
By: mist598
  Oracle SQL
8i
By: Hometown1 on Wed, 12 March 2014
10 441 Wed, 12 March 2014 13:12
By: Solomon Yakobson
  Error ocurred calling a Web Service using UTL_HTTP
Oracle Database, 10g Enterprise Edition Release 10.2.0.4.0, HP-UX
By: gusmenp on Thu, 27 June 2013
5 1745 Wed, 12 March 2014 10:48
By: gusmenp
  Initialisation of private variable
By: ibergo on Tue, 11 March 2014
15 793 Wed, 12 March 2014 04:45
By: ibergo
icon5.gif How to mainatin history of table.
By: na.dharma@gmail.com on Tue, 11 March 2014
6 524 Tue, 11 March 2014 09:55
By: John Watson
  sending email outsude the domain via database
10g(10.2.0.5) on windows2008 operating system
By: arhaan on Tue, 11 March 2014
6 560 Tue, 11 March 2014 07:30
By: Michel Cadot
  How to avoid self join.
Oracle 11g
By: na.dharma@gmail.com on Tue, 11 March 2014
3 442 Tue, 11 March 2014 07:29
By: Michel Cadot
  partition on oracle big size tables ?
oracle 11g/r2/unix
By: balaji123 on Fri, 07 March 2014
4 394 Tue, 11 March 2014 04:04
By: vslabs
  How I can increase size of message UTL_MAIL I need to send more than 10,000 characters
10g(10.2.0.5) on windows2008
By: arhaan on Sun, 09 March 2014
5 529 Tue, 11 March 2014 03:43
By: vslabs
  Excute procedure
By: man silence on Mon, 10 March 2014
4 315 Mon, 10 March 2014 19:58
By: man silence
  01843. 00000 - "not a valid month"
sql developer, 11g
By: meeplsql on Mon, 10 March 2014
13 690 Mon, 10 March 2014 18:11
By: Solomon Yakobson
  Generating Random numbers query
Oracle 11.2.0.3, Linux
By: sspn2010 on Mon, 10 March 2014
4 382 Mon, 10 March 2014 15:15
By: sspn2010
  clarification about selectivity
Oracle Database 11.2.0.2.0, Windows XP SP3
By: Roger22 on Sun, 09 March 2014
4 361 Mon, 10 March 2014 03:54
By: Roger22
  user parameters
Oracle 10g
By: m.abdulhaq on Thu, 06 March 2014
6 491 Sat, 08 March 2014 11:35
By: m.abdulhaq
  Want to get first day of last month
11g
By: cplusplus1 on Fri, 07 March 2014
3 343 Fri, 07 March 2014 14:39
By: John Watson
  create new record from LAST record with SQL
Oracle Database 11g
By: oralover2006 on Thu, 06 March 2014
6 505 Fri, 07 March 2014 07:46
By: Michel Cadot
icon5.gif Simple Question
By: Crimzon on Fri, 07 March 2014
4 246 Fri, 07 March 2014 06:00
By: Michel Cadot
  unit calculation
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003
By: hissam78 on Thu, 06 March 2014
3 434 Fri, 07 March 2014 01:16
By: hissam78
  Validate data
Oracle 10g
By: m.abdulhaq on Tue, 25 February 2014
9 663 Thu, 06 March 2014 20:44
By: m.abdulhaq
  how to remove redundant data
By: evivek on Thu, 06 March 2014
1 243 Thu, 06 March 2014 14:53
By: BlackSwan
  Varchar2 Length
By: OraFaq13 on Wed, 05 March 2014
3 334 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 1028 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 399 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 1656 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 744 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 606 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 406 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 339 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 257 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 490 Tue, 04 March 2014 09:21
By: Solomon Yakobson
  Columns values into rows
By: msinha8 on Tue, 04 March 2014
4 472 Tue, 04 March 2014 05:52
By: Michel Cadot
  Locked Stats
11
By: blackpanther on Mon, 03 March 2014
2 278 Tue, 04 March 2014 02:33
By: Roachcoach
  dbms_output.put_line
oracle11g/r2/unix
By: balaji123 on Tue, 04 March 2014
2 322 Tue, 04 March 2014 02:09
By: John Watson
  Rollup using with UNION
By: zsiddiquis on Mon, 03 March 2014
6 524 Mon, 03 March 2014 12:01
By: Michel Cadot
  Index on column name "number"!!!
By: vulcanjibe on Fri, 28 February 2014
7 734 Sat, 01 March 2014 11:29
By: vulcanjibe
icon4.gif SQL - QUERY
By: vippysharma on Fri, 28 February 2014
8 820 Sat, 01 March 2014 09:53
By: Michel Cadot
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 22 20:30:07 CDT 2014

Total time taken to generate the page: 0.13320 seconds