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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 44085 Mon, 05 September 2011 02:20
By: Littlefoot
  paramter values fetch from dual and apply to query
oracle 11 ,linux
By: miroconnect@yahoo.com on Fri, 30 January 2015
3 227 Fri, 30 January 2015 16:56
By: miroconnect@yahoo.com
  REGEXP_REPLACE to remove non-native english characters
Oracle 11g
By: wtolentino on Fri, 30 January 2015
0 190 Fri, 30 January 2015 15:59
By: wtolentino
  Convert XML data as blob image
Oracle Database 11g
By: wtolentino on Thu, 29 January 2015
3 299 Fri, 30 January 2015 10:08
By: BlackSwan
  REGULAR_EXPRESSION query
Oracle 11g
By: srinivas.k2005 on Thu, 29 January 2015
7 577 Fri, 30 January 2015 05:49
By: Roachcoach
  E-Mail sending issue from Oracle Database
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Fri, 12 December 2014
10 2545 Fri, 30 January 2015 00:08
By: BlackSwan
  Creating boundaries in between xml elements
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production ( 1 2)
By: wantmannu on Wed, 28 January 2015
41 600 Thu, 29 January 2015 17:21
By: Solomon Yakobson
  ORA-01460: unimplemented or unreasonable conversion requested
Oracle 11g
By: johnwcv on Thu, 29 January 2015
2 78 Thu, 29 January 2015 15:34
By: BlackSwan
  Transpose rows to columns without an aggregation
Oracle 11g
By: rangan.s on Thu, 29 January 2015
4 202 Thu, 29 January 2015 12:05
By: Solomon Yakobson
  ora-12096 error in materialized view (2 threads merged by bb)
oracle 10g
By: prashant_ora on Mon, 05 September 2011
8 12900 Thu, 29 January 2015 06:28
By: Michel Cadot
  need a query for following description
By: pmrnk03 on Thu, 29 January 2015
4 289 Thu, 29 January 2015 03:57
By: pmrnk03
  Query taking too long to execute and then throws an error. Need to change the SQL query
Oracle 11g, Oracle SQL developer 4
By: SQL_Dev on Tue, 27 January 2015
9 781 Thu, 29 January 2015 01:33
By: John Watson
  How to insert with100 Million record's sql query result into another table 1 million by 1 million
Oracle 10g
By: victoryhendry on Fri, 09 January 2015
12 679 Wed, 28 January 2015 15:54
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
11 674 Wed, 28 January 2015 13:29
By: Barbara Boehmer
  unknown procedure or function
By: palpali on Tue, 27 January 2015
20 912 Wed, 28 January 2015 01:23
By: palpali
  Group by clause doubt - Can you please suggest me the query to this problem???
Oracle, windows
By: PHCR on Tue, 23 December 2014
11 1892 Tue, 27 January 2015 12:01
By: ravikanth_b
icon5.gif Asp.Net Application hangs until oracle package is recompiled
Oracle Database 11g Release 11.2.0.1.0 64bit CentOS 6.5
By: praveenpraj on Tue, 27 January 2015
2 350 Tue, 27 January 2015 09:11
By: Lalit Kumar B
  Need sql script or proceedure
11G R2
By: mvrkr44 on Mon, 26 January 2015
23 436 Mon, 26 January 2015 10:29
By: cookiemonster
  variable declaration in procedure if we are calling the procedure within itself
By: chavva.kiru@gmail.com on Sun, 25 January 2015
1 224 Sun, 25 January 2015 16:52
By: Solomon Yakobson
  Updating a table with group by
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: wantmannu on Sat, 24 January 2015
6 431 Sun, 25 January 2015 11:29
By: wantmannu
  SQL Loader ; SQL
11g
By: mapps0999@gmail.com on Sun, 25 January 2015
8 428 Sun, 25 January 2015 07:50
By: BlackSwan
  sql query to get avg value
Oracle 11g
By: thelearner on Fri, 23 January 2015
11 890 Sun, 25 January 2015 04:36
By: John Watson
  REG:Variable declaration in procedure
By: chavva.kiru@gmail.com on Sat, 24 January 2015
2 350 Sun, 25 January 2015 01:06
By: Michel Cadot
  error while running procedure
By: chavva.kiru@gmail.com on Sun, 18 January 2015
3 437 Sat, 24 January 2015 23:43
By: chavva.kiru@gmail.com
  need to get perfect query
oracle database
By: Ganesha on Sat, 24 January 2015
2 280 Sat, 24 January 2015 14:48
By: Michel Cadot
  construct full date based on value yyyymm
11g
By: cplusplus1 on Fri, 23 January 2015
21 678 Sat, 24 January 2015 05:11
By: Michel Cadot
  Subtracting Years from As_Of_Date
PL/SQL, Version 9.0.6.1665
By: jburdell on Fri, 23 January 2015
6 214 Fri, 23 January 2015 16:10
By: Bill B
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
5 234 Fri, 23 January 2015 13:43
By: EdStevens
  How to find first prior number from current date
By: aaditya321 on Thu, 15 January 2015
36 3171 Fri, 23 January 2015 09:27
By: Lalit Kumar B
  Error While Fetching Data Through Database Link In Oracle
By: qanita786 on Fri, 23 January 2015
8 480 Fri, 23 January 2015 06:32
By: EdStevens
  Special character issues
By: raopatwariyahoocom on Thu, 22 January 2015
6 536 Fri, 23 January 2015 03:00
By: Michel Cadot
  Help with REGEXP
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: mokarem on Wed, 14 January 2015
25 3034 Fri, 23 January 2015 01:08
By: m.abdulhaq
  Query on pagination Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
By: gopal.biswal on Sat, 17 January 2015
2 856 Thu, 22 January 2015 21:44
By: gopal.biswal
  Need help on hierarchial query
Oracle 11.2.0.4, Linus
By: sspn2010 on Thu, 22 January 2015
5 168 Thu, 22 January 2015 13:11
By: sspn2010
  Need help on a query
Oracle 10G
By: bahubcd on Thu, 22 January 2015
4 166 Thu, 22 January 2015 11:44
By: John Watson
  bulk collect
By: palpali on Wed, 21 January 2015
10 448 Thu, 22 January 2015 09:11
By: palpali
  Distributing a total amount (payment) according to individual records (requests)
11.2.0.1.0
By: OraFerro on Thu, 22 January 2015
4 362 Thu, 22 January 2015 08:23
By: Solomon Yakobson
  How to trim the last matching string using regexp_substr
By: oracleso on Wed, 21 January 2015
9 878 Thu, 22 January 2015 07:59
By: Michel Cadot
  Populate List from Java
Oracle 10g
By: Xandot on Thu, 22 January 2015
1 581 Thu, 22 January 2015 07:48
By: Michel Cadot
  status based use of SUM function
By: suji6281 on Thu, 22 January 2015
5 587 Thu, 22 January 2015 05:00
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: Fri Jan 30 23:45:07 CST 2015

Total time taken to generate the page: 0.11375 seconds