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
  Need to get records equal to the number of month days.
Oracle Database 10g Rel.2
By: mazam on Fri, 21 February 2014
8 690 Sat, 22 February 2014 00:18
By: Michel Cadot
icon2.gif Performance impact by using Number/Char column as primary key
11g, AIX
By: harpreetsinghkup on Fri, 21 February 2014
4 237 Fri, 21 February 2014 20:02
By: Kevin Meade
  Perform minus operation between two Pl/SQL Record Type Tables
By: ady_koolz on Fri, 21 February 2014
9 449 Fri, 21 February 2014 15:54
By: DrabJay
  Query to find different league matches between team, no repeatitive league matches (only once)
Oracle 11g R1 Linux
By: anil_mk on Fri, 21 February 2014
4 354 Fri, 21 February 2014 08:12
By: msol25
  Need to put results of SQL into a table
Oracle SQL
By: skbytes on Fri, 21 February 2014
3 424 Fri, 21 February 2014 05:06
By: skbytes
  Oracle Partitioning
Oracle 10 G, Windows 7
By: s4.ora on Fri, 21 February 2014
3 292 Fri, 21 February 2014 03:22
By: Michel Cadot
  Multiple Output values in a dynamic sql
10.2.0.4, Windows
By: sandba00 on Thu, 20 February 2014
7 470 Fri, 21 February 2014 03:11
By: Michel Cadot
  Retrieve Data from a Table based on OR condition
Oracle 11G, Sun Solaris
By: ady_koolz on Tue, 11 February 2014
5 324 Fri, 21 February 2014 01:18
By: ady_koolz
  Timestamp gets truncated from cursor for loop
PL/SQL 11
By: DIPRINKS on Thu, 20 February 2014
2 273 Thu, 20 February 2014 11:42
By: DIPRINKS
  how to get previous row value?
By: pmreddy.mahi@gmail.com on Thu, 20 February 2014
26 1128 Thu, 20 February 2014 08:55
By: cookiemonster
  Future Partitions
Oracle 11g
By: srinivas.k2005 on Thu, 20 February 2014
2 235 Thu, 20 February 2014 08:23
By: srinivas.k2005
  alias name in where clause
By: anniepeteroracle on Thu, 20 February 2014
5 444 Thu, 20 February 2014 08:20
By: Michel Cadot
  Sys_refcursor
By: Rarawshenkiv on Thu, 20 February 2014
1 174 Thu, 20 February 2014 06:46
By: msol25
  no of counts from case when
By: ashwanth77 on Thu, 20 February 2014
3 422 Thu, 20 February 2014 06:18
By: Michel Cadot
  Procedure.,
By: Rarawshenkiv on Thu, 20 February 2014
5 402 Thu, 20 February 2014 05:56
By: Michel Cadot
  Terrifying result of sql-query, need explanation.
By: Cott on Tue, 18 February 2014
29 1215 Thu, 20 February 2014 03:03
By: Roachcoach
  Unique/check constraint on two columns
Oracle Database 11g Express Edition Release 11.2.0.2.0
By: kojot on Wed, 19 February 2014
7 467 Thu, 20 February 2014 00:25
By: kojot
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 266 Wed, 19 February 2014 13:29
By: John Watson
  pls help in query
pl sql
By: simplesanju on Wed, 19 February 2014
2 248 Wed, 19 February 2014 13:18
By: Michel Cadot
  Value multiplication help
Oracle 10g Pl/SQL
By: pmreddy.mahi@gmail.com on Wed, 19 February 2014
8 404 Wed, 19 February 2014 10:46
By: pmreddy.mahi@gmail.com
  Creating a table and referencing that table in same package.
Oracle 11g PL/SQL
By: skbytes on Wed, 19 February 2014
25 876 Wed, 19 February 2014 09:05
By: skbytes
  Exception while creating table using EXECUTE IMMEDIATE
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Wed, 19 February 2014
3 283 Wed, 19 February 2014 04:28
By: Manoj.Gupta.91
  get the data between the dates
win 7, oracle 11G
By: nischalinn on Tue, 18 February 2014
8 525 Wed, 19 February 2014 02:34
By: cookiemonster
  find latest ddl statement happened in table
11.2,AIX
By: shivshankar on Wed, 19 February 2014
3 258 Wed, 19 February 2014 00:53
By: Michel Cadot
  Struggling with DBMS_JOB.SUBMIT syntax
11g
By: bristolsmithy on Tue, 18 February 2014
3 348 Tue, 18 February 2014 15:15
By: bristolsmithy
  Oracle Pl/SQL Case Statement
PL/SQL 10.0
By: Uncle_Jake on Tue, 18 February 2014
1 256 Tue, 18 February 2014 13:37
By: Michel Cadot
  Query help
Oracle 11.2.0.3, Linux
By: sspn2010 on Tue, 18 February 2014
5 318 Tue, 18 February 2014 13:21
By: sspn2010
  Alter Table Command in relation to another table primary key
Oracle SQL Developer 4.0.0.13
By: Lahkra on Tue, 18 February 2014
11 424 Tue, 18 February 2014 11:07
By: BlackSwan
  First Character in "numeric-Alpha"
10.2.0
By: bluetooth420 on Mon, 10 February 2014
9 526 Tue, 18 February 2014 07:03
By: cookiemonster
  Oracle Compare 2 Tables
11g
By: developer12 on Tue, 18 February 2014
1 175 Tue, 18 February 2014 05:54
By: Michel Cadot
  not in, not exists query
By: mist598 on Mon, 17 February 2014
15 841 Tue, 18 February 2014 04:04
By: cookiemonster
  materialized view
oracle 10 g
By: oraclehi on Tue, 18 February 2014
5 292 Tue, 18 February 2014 03:23
By: Michel Cadot
  how to import table data from sql plus
oracle 10g
By: jgjeetu on Mon, 17 February 2014
26 1075 Tue, 18 February 2014 01:20
By: Littlefoot
  EMAIL from ORACLE8i using Corporate Netwrok
oracle 8i
By: na.vaithianathan on Sat, 15 February 2014
8 530 Mon, 17 February 2014 22:31
By: BlackSwan
  Query to get Status of Students as 'Pass' or 'Fail' Using Date Condition
Oracle 11g
By: sonudev on Wed, 12 February 2014
3 238 Mon, 17 February 2014 13:42
By: sonudev
  ORDER BY the day of the week
ORACLE DB SQL
By: hans_cellc on Mon, 17 February 2014
5 195 Mon, 17 February 2014 04:26
By: hans_cellc
  FLASHBACK QUERY
11g r2
By: mvrkr44 on Sun, 16 February 2014
7 511 Mon, 17 February 2014 03:41
By: John Watson
  SQL gets not result in Ora Enterprise 11.1.0.7.0 but in 10 and 11 XE it does
Ora Enterprise 11.1.0.7.0 on WinServer 2008 R2
By: geomac on Thu, 08 November 2012
9 564 Mon, 17 February 2014 03:41
By: geomac
  FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES
By: jgjeetu on Sun, 16 February 2014
10 621 Mon, 17 February 2014 01:28
By: Littlefoot
  What are valid and invalid functions in PL-SQL
Oracle
By: jgjeetu on Sat, 15 February 2014
2 267 Mon, 17 February 2014 00:18
By: msol25
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: Wed Apr 23 18:55:29 CDT 2014

Total time taken to generate the page: 0.07212 seconds