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
  fetch the same value with & without using the trunc ??
By: mist598 on Tue, 03 February 2015
24 898 Sun, 15 February 2015 08:21
By: Lalit Kumar B
  Split row into two or more rows
Oracle 10G r2
By: mmohsinaziz on Thu, 12 February 2015
3 391 Thu, 12 February 2015 23:48
By: Lalit Kumar B
icon4.gif Assign the SQL statement to a variable
Oracle 9.1
By: mikelala on Tue, 10 February 2015
17 1061 Thu, 12 February 2015 22:55
By: BlackSwan
  Need help on using regexp_substr in SQL
Oracle 11g
By: 3183h on Thu, 12 February 2015
2 264 Thu, 12 February 2015 19:27
By: Barbara Boehmer
  PLS-00597: PLSQL Record and Nested
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production, Windows 7
By: ninan on Wed, 11 February 2015
10 697 Thu, 12 February 2015 10:42
By: Solomon Yakobson
  convert string values into rows
oracle11
By: oracle_Raj on Wed, 11 February 2015
6 455 Thu, 12 February 2015 10:03
By: oracle_Raj
  blog image display in utl_mail
Oracle 10g
By: m.abdulhaq on Thu, 12 February 2015
6 484 Thu, 12 February 2015 05:15
By: m.abdulhaq
  SQL output to HTML table in email notification - possible?
By: RGall320 on Wed, 11 February 2015
1 367 Wed, 11 February 2015 12:21
By: Mahesh Rajendran
  Spliting of String
Oracle 10g
By: sss111ind on Thu, 05 February 2015
26 1054 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 425 Wed, 11 February 2015 07:25
By: Michel Cadot
  Oracles recursive Connect By
By: ksetty on Tue, 10 February 2015
7 432 Tue, 10 February 2015 11:21
By: Solomon Yakobson
  numeric value error
By: orcle_us on Tue, 10 February 2015
19 521 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 360 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 900 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 705 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 667 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 856 Sat, 07 February 2015 13:29
By: orcle_us
  Getting boundaries
11.2.0.3
By: Amine on Tue, 03 February 2015
20 531 Fri, 06 February 2015 15:03
By: Amine
  Insert data through Java class
Oracle 10g
By: Xandot on Fri, 06 February 2015
7 374 Fri, 06 February 2015 07:24
By: Lalit Kumar B
  extract character between points
By: mmm286 on Fri, 06 February 2015
8 454 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 455 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 860 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 634 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 403 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 1319 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 965 Wed, 04 February 2015 03:46
By: Roachcoach
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
9 737 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 371 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 613 Tue, 03 February 2015 09:08
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
13 1138 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 407 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 915 Tue, 03 February 2015 04:01
By: Littlefoot
  Date format issues
12g
By: gorants on Sun, 01 February 2015
6 837 Mon, 02 February 2015 10:57
By: gorants
  Quicksort - problem with null values
By: remiz on Mon, 28 November 2005
9 4360 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 886 Sat, 31 January 2015 12:31
By: Solomon Yakobson
  SQL Loader ; SQL
11g
By: mapps0999@gmail.com on Sun, 25 January 2015
9 701 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 469 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 566 Fri, 30 January 2015 10:08
By: BlackSwan
  REGULAR_EXPRESSION query
Oracle 11g
By: srinivas.k2005 on Thu, 29 January 2015
7 798 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 3079 Fri, 30 January 2015 00:08
By: BlackSwan
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 31 15:46:31 CDT 2015

Total time taken to generate the page: 0.11300 seconds