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
  ORA-00001: unique constraint (UNKNOWN.obj#=179690) violated
Oracle11G EE
By: famegaurav on Thu, 05 February 2015
6 363 Thu, 05 February 2015 03:28
By: cookiemonster
  Explain code
Oracle,11.2.0.2.0 - Production,Win7
By: shumail on Wed, 04 February 2015
2 335 Thu, 05 February 2015 00:53
By: Michel Cadot
  How to make logic
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Sun, 01 February 2015
10 1211 Wed, 04 February 2015 23:04
By: shumail
  What is the effect of index for DELETE operation
Oracle 11g
By: rak.plsql on Sat, 31 January 2015
10 842 Wed, 04 February 2015 03:46
By: Roachcoach
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
9 620 Wed, 04 February 2015 02:55
By: cookiemonster
  I want find how many hour,minutes,seconds is taken from task_stared and task_end.
Oracle 11g
By: na.dharma@gmail.com on Tue, 03 February 2015
6 240 Tue, 03 February 2015 12:55
By: EdStevens
  Wait class snapshot wise using dba_hist_system_event
Aix
By: saurabhshukladba on Tue, 03 February 2015
10 449 Tue, 03 February 2015 09:08
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
13 1002 Tue, 03 February 2015 07:03
By: Michel Cadot
  Values on NUM_ROWS of DBA_TABLE is appearing as null for 48 records
11g, 11.2.0.1, window7
By: ashishkumarmahanta80 on Tue, 03 February 2015
2 316 Tue, 03 February 2015 06:53
By: ashishkumarmahanta80
  A hierarchical query problem
Oracle 11.2.0.3, MS Windows Server 2003
By: Littlefoot on Mon, 02 February 2015
13 788 Tue, 03 February 2015 04:01
By: Littlefoot
  Date format issues
12g
By: gorants on Sun, 01 February 2015
6 626 Mon, 02 February 2015 10:57
By: gorants
  Quicksort - problem with null values
By: remiz on Mon, 28 November 2005
9 4087 Sun, 01 February 2015 21:28
By: BlackSwan
  REGEXP_REPLACE to remove non-native english characters
Oracle 11g
By: wtolentino on Fri, 30 January 2015
2 744 Sat, 31 January 2015 12:31
By: Solomon Yakobson
  SQL Loader ; SQL
11g
By: mapps0999@gmail.com on Sun, 25 January 2015
9 579 Fri, 30 January 2015 23:59
By: jgjeetu
  paramter values fetch from dual and apply to query
oracle 11 ,linux
By: miroconnect@yahoo.com on Fri, 30 January 2015
3 353 Fri, 30 January 2015 16:56
By: miroconnect@yahoo.com
  Convert XML data as blob image
Oracle Database 11g
By: wtolentino on Thu, 29 January 2015
3 409 Fri, 30 January 2015 10:08
By: BlackSwan
  REGULAR_EXPRESSION query
Oracle 11g
By: srinivas.k2005 on Thu, 29 January 2015
7 688 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 2731 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 734 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 182 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 378 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 13063 Thu, 29 January 2015 06:28
By: Michel Cadot
  need a query for following description
By: pmrnk03 on Thu, 29 January 2015
4 376 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 907 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 774 Wed, 28 January 2015 15:54
By: BlackSwan
  unknown procedure or function
By: palpali on Tue, 27 January 2015
20 1000 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 2031 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 402 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 516 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 282 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 498 Sun, 25 January 2015 11:29
By: wantmannu
  sql query to get avg value
Oracle 11g
By: thelearner on Fri, 23 January 2015
11 979 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 394 Sun, 25 January 2015 01:06
By: Michel Cadot
  error while running procedure
By: chavva.kiru@gmail.com on Sun, 18 January 2015
3 487 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 350 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 765 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 289 Fri, 23 January 2015 16:10
By: Bill B
  How to find first prior number from current date
By: aaditya321 on Thu, 15 January 2015
36 3383 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 514 Fri, 23 January 2015 06:32
By: EdStevens
  Special character issues
By: raopatwariyahoocom on Thu, 22 January 2015
6 587 Fri, 23 January 2015 03: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: Sun Mar 29 21:22:02 CDT 2015

Total time taken to generate the page: 0.12920 seconds