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
  Spliting of String
Oracle 10g
By: sss111ind on Thu, 05 February 2015
26 1031 Wed, 11 February 2015 07:36
By: BlackSwan
  how do I produce columns based on values within a column
By: Mr CPT on Wed, 11 February 2015
2 413 Wed, 11 February 2015 07:25
By: Michel Cadot
  Oracles recursive Connect By
By: ksetty on Tue, 10 February 2015
7 419 Tue, 10 February 2015 11:21
By: Solomon Yakobson
  numeric value error
By: orcle_us on Tue, 10 February 2015
19 511 Tue, 10 February 2015 10:58
By: orcle_us
  How to Create Database Link In Oracle 8.1.7
By: qanita786 on Tue, 10 February 2015
2 352 Tue, 10 February 2015 06:35
By: Michel Cadot
  split a number or dates by slab (merged)
By: mahbbu on Sun, 08 February 2015
14 885 Tue, 10 February 2015 05:39
By: gazzag
  how to get column names from the table
By: orcle_us on Sat, 07 February 2015
11 696 Sun, 08 February 2015 08:58
By: orcle_us
  Sql query to read the hardcoded values
By: koyalmudi007@gmail.com on Fri, 06 February 2015
13 661 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 812 Sat, 07 February 2015 13:29
By: orcle_us
  Getting boundaries
11.2.0.3
By: Amine on Tue, 03 February 2015
20 520 Fri, 06 February 2015 15:03
By: Amine
  Insert data through Java class
Oracle 10g
By: Xandot on Fri, 06 February 2015
7 364 Fri, 06 February 2015 07:24
By: Lalit Kumar B
  extract character between points
By: mmm286 on Fri, 06 February 2015
8 442 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 446 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 849 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 566 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 400 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 1309 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 953 Wed, 04 February 2015 03:46
By: Roachcoach
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
9 722 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 359 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 584 Tue, 03 February 2015 09:08
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
13 1130 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 397 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 901 Tue, 03 February 2015 04:01
By: Littlefoot
  Date format issues
12g
By: gorants on Sun, 01 February 2015
6 810 Mon, 02 February 2015 10:57
By: gorants
  Quicksort - problem with null values
By: remiz on Mon, 28 November 2005
9 4327 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 869 Sat, 31 January 2015 12:31
By: Solomon Yakobson
  SQL Loader ; SQL
11g
By: mapps0999@gmail.com on Sun, 25 January 2015
9 689 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 459 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 548 Fri, 30 January 2015 10:08
By: BlackSwan
  REGULAR_EXPRESSION query
Oracle 11g
By: srinivas.k2005 on Thu, 29 January 2015
7 789 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 3036 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 931 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 294 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 541 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 13336 Thu, 29 January 2015 06:28
By: Michel Cadot
  need a query for following description
By: pmrnk03 on Thu, 29 January 2015
4 477 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 1053 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 955 Wed, 28 January 2015 15:54
By: BlackSwan
  unknown procedure or function
By: palpali on Tue, 27 January 2015
20 1124 Wed, 28 January 2015 01:23
By: palpali
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: Mon Aug 03 18:48:31 CDT 2015

Total time taken to generate the page: 0.07813 seconds