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
  Order by with WITH clause
Oracle 10g
By: sss111ind on Thu, 26 February 2015
3 457 Thu, 26 February 2015 05:31
By: sss111ind
  How to handle unknown number of variables
By: Nuggit on Thu, 19 February 2015
14 1094 Thu, 26 February 2015 02:34
By: mnitu
  creation of records with respect to the delimited data from a column of base table
By: saralay on Tue, 24 February 2015
5 531 Wed, 25 February 2015 07:31
By: Kevin Meade
  Oracle dbms scheduler
Oracle 11g
By: veeraiahmannem on Tue, 24 February 2015
10 669 Wed, 25 February 2015 07:13
By: sss111ind
  using function in select statement giving same value ( 1 2)
By: mist598 on Tue, 24 February 2015
41 862 Tue, 24 February 2015 09:11
By: BlackSwan
  PL/SQL for Insert/Update ( 1 2)
By: aimy on Thu, 12 February 2015
40 1861 Tue, 24 February 2015 03:50
By: Michel Cadot
  Table Updates
Oracle 11g
By: Genesys on Mon, 23 February 2015
15 899 Tue, 24 February 2015 00:39
By: Genesys
  How to delete data from all the tables with one Query?
10g
By: manisngpl on Mon, 23 February 2015
9 768 Mon, 23 February 2015 12:34
By: Bill B
  ora-22288
11gR2 RHEL5.5
By: smunir362 on Thu, 19 February 2015
6 842 Sat, 21 February 2015 11:50
By: BlackSwan
  New to using Oracle. Need help!
By: jdmas on Thu, 19 February 2015
6 537 Thu, 19 February 2015 12:41
By: Michel Cadot
  To determine if the column value is decreasing
Oracle 11g
By: roblvl on Thu, 19 February 2015
2 406 Thu, 19 February 2015 07:29
By: Littlefoot
  Oracle 11g
Query plan
By: ramya_162 on Thu, 19 February 2015
2 395 Thu, 19 February 2015 07:08
By: EdStevens
  Trunc Date
Oracle SQL
By: naga78 on Thu, 19 February 2015
2 465 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 728 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 1201 Wed, 18 February 2015 06:43
By: Primordial
  how to grant database link to user
By: qanita786 on Tue, 17 February 2015
19 838 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 602 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 782 Tue, 17 February 2015 02:20
By: Lalit Kumar B
  "Client copy" with PL/SQL
By: wurmi on Thu, 12 February 2015
19 855 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 1118 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 606 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 1236 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 359 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 915 Thu, 12 February 2015 10:42
By: Solomon Yakobson
  convert string values into rows
oracle11
By: oracle_Raj on Wed, 11 February 2015
6 608 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 696 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 497 Wed, 11 February 2015 12:21
By: Mahesh Rajendran
  Spliting of String
Oracle 10g
By: sss111ind on Thu, 05 February 2015
26 1335 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 556 Wed, 11 February 2015 07:25
By: Michel Cadot
  Oracles recursive Connect By
By: ksetty on Tue, 10 February 2015
7 615 Tue, 10 February 2015 11:21
By: Solomon Yakobson
  numeric value error
By: orcle_us on Tue, 10 February 2015
19 722 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 475 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 1101 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 872 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 836 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 1275 Sat, 07 February 2015 13:29
By: orcle_us
  Getting boundaries
11.2.0.3
By: Amine on Tue, 03 February 2015
20 691 Fri, 06 February 2015 15:03
By: Amine
  Insert data through Java class
Oracle 10g
By: Xandot on Fri, 06 February 2015
7 531 Fri, 06 February 2015 07:24
By: Lalit Kumar B
  extract character between points
By: mmm286 on Fri, 06 February 2015
8 621 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 562 Fri, 06 February 2015 01:49
By: John Watson
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: Thu Apr 28 15:32:00 CDT 2016

Total time taken to generate the page: 0.15372 seconds