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
  Identity column inserts duplicates with Insert All statement, unique constraint violation
Oracle database, 12.1.0.2, Any OS
By: Lalit Kumar B on Tue, 17 February 2015
4 699 Tue, 17 February 2015 02:20
By: Lalit Kumar B
  "Client copy" with PL/SQL
By: wurmi on Thu, 12 February 2015
19 799 Sun, 15 February 2015 09:29
By: wurmi
  fetch the same value with & without using the trunc ??
By: mist598 on Tue, 03 February 2015
24 1054 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 538 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 1186 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 335 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 830 Thu, 12 February 2015 10:42
By: Solomon Yakobson
  convert string values into rows
oracle11
By: oracle_Raj on Wed, 11 February 2015
6 569 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 636 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 446 Wed, 11 February 2015 12:21
By: Mahesh Rajendran
  Spliting of String
Oracle 10g
By: sss111ind on Thu, 05 February 2015
26 1247 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 523 Wed, 11 February 2015 07:25
By: Michel Cadot
  Oracles recursive Connect By
By: ksetty on Tue, 10 February 2015
7 567 Tue, 10 February 2015 11:21
By: Solomon Yakobson
  numeric value error
By: orcle_us on Tue, 10 February 2015
19 669 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 452 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 1049 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 830 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 794 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 1151 Sat, 07 February 2015 13:29
By: orcle_us
  Getting boundaries
11.2.0.3
By: Amine on Tue, 03 February 2015
20 663 Fri, 06 February 2015 15:03
By: Amine
  Insert data through Java class
Oracle 10g
By: Xandot on Fri, 06 February 2015
7 494 Fri, 06 February 2015 07:24
By: Lalit Kumar B
  extract character between points
By: mmm286 on Fri, 06 February 2015
8 580 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 536 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 973 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 1008 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 499 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 1460 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 1085 Wed, 04 February 2015 03:46
By: Roachcoach
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
9 858 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 463 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 712 Tue, 03 February 2015 09:08
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
13 1271 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 485 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 1041 Tue, 03 February 2015 04:01
By: Littlefoot
  Date format issues
12g
By: gorants on Sun, 01 February 2015
6 1010 Mon, 02 February 2015 10:57
By: gorants
  Quicksort - problem with null values
By: remiz on Mon, 28 November 2005
9 4629 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 1002 Sat, 31 January 2015 12:31
By: Solomon Yakobson
  SQL Loader ; SQL
11g
By: mapps0999@gmail.com on Sun, 25 January 2015
9 813 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 558 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 712 Fri, 30 January 2015 10: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: Fri Feb 12 04:24:45 CST 2016

Total time taken to generate the page: 0.13122 seconds