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
  Sql query to read the hardcoded values
By: koyalmudi007@gmail.com on Fri, 06 February 2015
13 567 Sun, 08 February 2015 06:28
By: Solomon Yakobson
  ORA-06550: line 15, column 5: PLS-00103: Encountered the symbol "IF" when expecting one of the follo
oracle11g
By: orcle_us on Fri, 06 February 2015
14 627 Sat, 07 February 2015 13:29
By: orcle_us
  Getting boundaries
11.2.0.3
By: Amine on Tue, 03 February 2015
20 422 Fri, 06 February 2015 15:03
By: Amine
  Insert data through Java class
Oracle 10g
By: Xandot on Fri, 06 February 2015
7 296 Fri, 06 February 2015 07:24
By: Lalit Kumar B
  extract character between points
By: mmm286 on Fri, 06 February 2015
8 361 Fri, 06 February 2015 04:33
By: Littlefoot
icon5.gif query in CASE expression in select
Oracle 11
By: pallaviprakash on Thu, 05 February 2015
3 363 Fri, 06 February 2015 01:49
By: John Watson
  More than one column in Connect by prior
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: mamalik on Mon, 02 February 2015
15 769 Thu, 05 February 2015 23:52
By: Lalit Kumar B
  ORA-00001: unique constraint (UNKNOWN.obj#=179690) violated
Oracle11G EE
By: famegaurav on Thu, 05 February 2015
6 391 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 343 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 1234 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 869 Wed, 04 February 2015 03:46
By: Roachcoach
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
9 642 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 260 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 486 Tue, 03 February 2015 09:08
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
13 1032 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 333 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 812 Tue, 03 February 2015 04:01
By: Littlefoot
  Date format issues
12g
By: gorants on Sun, 01 February 2015
6 673 Mon, 02 February 2015 10:57
By: gorants
  Quicksort - problem with null values
By: remiz on Mon, 28 November 2005
9 4150 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 768 Sat, 31 January 2015 12:31
By: Solomon Yakobson
  SQL Loader ; SQL
11g
By: mapps0999@gmail.com on Sun, 25 January 2015
9 608 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 384 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 439 Fri, 30 January 2015 10:08
By: BlackSwan
  REGULAR_EXPRESSION query
Oracle 11g
By: srinivas.k2005 on Thu, 29 January 2015
7 720 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 2798 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 775 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 210 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 420 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 13127 Thu, 29 January 2015 06:28
By: Michel Cadot
  need a query for following description
By: pmrnk03 on Thu, 29 January 2015
4 405 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 933 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 815 Wed, 28 January 2015 15:54
By: BlackSwan
  unknown procedure or function
By: palpali on Tue, 27 January 2015
20 1025 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 2067 Tue, 27 January 2015 12:01
By: ravikanth_b
  Need sql script or proceedure
11G R2
By: mvrkr44 on Mon, 26 January 2015
23 539 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 301 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 522 Sun, 25 January 2015 11:29
By: wantmannu
  sql query to get avg value
Oracle 11g
By: thelearner on Fri, 23 January 2015
11 998 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 426 Sun, 25 January 2015 01:06
By: Michel Cadot
  error while running procedure
By: chavva.kiru@gmail.com on Sun, 18 January 2015
3 518 Sat, 24 January 2015 23:43
By: chavva.kiru@gmail.com
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: Sat Apr 25 11:25:15 CDT 2015

Total time taken to generate the page: 0.44829 seconds