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
  When I joining char and varchar2 column, I am not getting now rows
Oralce 11g
By: na.dharma@gmail.com on Mon, 24 February 2014
7 565 Mon, 24 February 2014 10:42
By: Solomon Yakobson
  Employee(s) Getting Less Than the Average Salary
Oracle 10g
By: sonudev on Wed, 19 February 2014
13 736 Mon, 24 February 2014 08:58
By: cookiemonster
  Split a varchar variable
11.2.0.3.0
By: Amine on Sun, 23 February 2014
9 773 Sun, 23 February 2014 15:29
By: Amine
  Need to get records equal to the number of month days.
Oracle Database 10g Rel.2
By: mazam on Fri, 21 February 2014
8 787 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 325 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 565 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 458 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 490 Fri, 21 February 2014 05:06
By: skbytes
  Oracle Partitioning
Oracle 10 G, Windows 7
By: s4.ora on Fri, 21 February 2014
3 346 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 549 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 379 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 416 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 1241 Thu, 20 February 2014 08:55
By: cookiemonster
  Future Partitions
Oracle 11g
By: srinivas.k2005 on Thu, 20 February 2014
2 286 Thu, 20 February 2014 08:23
By: srinivas.k2005
  alias name in where clause
By: anniepeteroracle on Thu, 20 February 2014
5 513 Thu, 20 February 2014 08:20
By: Michel Cadot
  no of counts from case when
By: ashwanth77 on Thu, 20 February 2014
3 498 Thu, 20 February 2014 06:18
By: Michel Cadot
  Procedure.,
By: Rarawshenkiv on Thu, 20 February 2014
5 464 Thu, 20 February 2014 05:56
By: Michel Cadot
  Terrifying result of sql-query, need explanation.
By: Cott on Tue, 18 February 2014
29 1295 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 583 Thu, 20 February 2014 00:25
By: kojot
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 346 Wed, 19 February 2014 13:29
By: John Watson
  Value multiplication help
Oracle 10g Pl/SQL
By: pmreddy.mahi@gmail.com on Wed, 19 February 2014
8 498 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 953 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 405 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 628 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 310 Wed, 19 February 2014 00:53
By: Michel Cadot
  Struggling with DBMS_JOB.SUBMIT syntax
11g
By: bristolsmithy on Tue, 18 February 2014
3 465 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 333 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 382 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 520 Tue, 18 February 2014 11:07
By: BlackSwan
  First Character in "numeric-Alpha"
10.2.0
By: bluetooth420 on Mon, 10 February 2014
9 626 Tue, 18 February 2014 07:03
By: cookiemonster
  Oracle Compare 2 Tables
11g
By: developer12 on Tue, 18 February 2014
1 236 Tue, 18 February 2014 05:54
By: Michel Cadot
  not in, not exists query
By: mist598 on Mon, 17 February 2014
15 918 Tue, 18 February 2014 04:04
By: cookiemonster
  materialized view
oracle 10 g
By: oraclehi on Tue, 18 February 2014
5 348 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 1202 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 611 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 307 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 247 Mon, 17 February 2014 04:26
By: hans_cellc
  FLASHBACK QUERY
11g r2
By: mvrkr44 on Sun, 16 February 2014
7 570 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 629 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 692 Mon, 17 February 2014 01:28
By: Littlefoot
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 Jul 31 23:08:13 CDT 2014

Total time taken to generate the page: 0.09564 seconds