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
  To determine if the column value is decreasing
Oracle 11g
By: roblvl on Thu, 19 February 2015
2 316 Thu, 19 February 2015 07:29
By: Littlefoot
  Oracle 11g
Query plan
By: ramya_162 on Thu, 19 February 2015
2 305 Thu, 19 February 2015 07:08
By: EdStevens
  Trunc Date
Oracle SQL
By: naga78 on Thu, 19 February 2015
2 339 Thu, 19 February 2015 05:35
By: Lalit Kumar B
  Outer join restricts a condition
RDBMS : 11.1.0.7.0 Oracle Applications : 12.1.2
By: mmasoomansari on Wed, 18 February 2015
3 551 Thu, 19 February 2015 05:16
By: mmasoomansari
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
2 673 Wed, 18 February 2015 06:43
By: Primordial
  how to grant database link to user
By: qanita786 on Tue, 17 February 2015
19 627 Wed, 18 February 2015 02:41
By: gazzag
  Concatenating numbers in virtual column expression throws ORA-12899: value too large for column
Oracle database, 12.1.0.1
By: Lalit Kumar B on Tue, 17 February 2015
2 357 Tue, 17 February 2015 02:29
By: Lalit Kumar B
  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 452 Tue, 17 February 2015 02:20
By: Lalit Kumar B
  "Client copy" with PL/SQL
By: wurmi on Thu, 12 February 2015
19 665 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 900 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 394 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 1063 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 267 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 700 Thu, 12 February 2015 10:42
By: Solomon Yakobson
  convert string values into rows
oracle11
By: oracle_Raj on Wed, 11 February 2015
6 456 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 485 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 1055 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 434 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 361 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 903 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 709 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 669 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 863 Sat, 07 February 2015 13:29
By: orcle_us
  Getting boundaries
11.2.0.3
By: Amine on Tue, 03 February 2015
20 534 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 457 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 456 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 862 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 640 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 406 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 1321 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 966 Wed, 04 February 2015 03:46
By: Roachcoach
  Convert to date
Oracle 11g , Win XP
By: rajivn786 on Fri, 23 January 2015
9 738 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 372 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 615 Tue, 03 February 2015 09:08
By: BlackSwan
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
13 1140 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 408 Tue, 03 February 2015 06:53
By: ashishkumarmahanta80
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 Sep 05 07:19:00 CDT 2015

Total time taken to generate the page: 0.13638 seconds