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
  Index on column name "number"!!!
By: vulcanjibe on Fri, 28 February 2014
7 734 Sat, 01 March 2014 11:29
By: vulcanjibe
icon4.gif SQL - QUERY
By: vippysharma on Fri, 28 February 2014
8 822 Sat, 01 March 2014 09:53
By: Michel Cadot
  Get previous quarter value
By: Bluebeam on Fri, 28 February 2014
1 211 Fri, 28 February 2014 18:56
By: BlackSwan
  SQL code to retrieve items in consective periods
using TOAD for Oracle
By: markw1906 on Fri, 28 February 2014
1 252 Fri, 28 February 2014 09:59
By: BlackSwan
  sql execution
oracle 11g/r2 unix
By: balaji123 on Fri, 28 February 2014
3 250 Fri, 28 February 2014 03:37
By: Roachcoach
  PIVOT - SQL Command not properly ended
TOAD 10.6
By: kupstar on Thu, 27 February 2014
13 528 Fri, 28 February 2014 02:53
By: cookiemonster
  Open Cursor for with an Exception Clause
11g Release 2 Windows
By: Duane on Thu, 27 February 2014
21 971 Thu, 27 February 2014 18:39
By: Duane
icon14.gif Get Min Value Where It Is Not Null ( 1 2)
By: aimy on Mon, 10 February 2014
45 2511 Thu, 27 February 2014 18:36
By: aimy
  Need help to build xml tag in oracle sql queries
oracle 10g
By: spatava on Thu, 27 February 2014
6 437 Thu, 27 February 2014 07:18
By: Solomon Yakobson
  DDL and DML
By: deepak439 on Wed, 26 February 2014
2 247 Thu, 27 February 2014 00:46
By: Michel Cadot
  Need invalid records
PL/SQL Release 11.2.0.2.0 ,Win 7 Professional
By: shumail on Sun, 23 February 2014
4 468 Wed, 26 February 2014 22:26
By: ken002
  how to make it by help of procedure
By: aaditya321 on Wed, 26 February 2014
3 399 Wed, 26 February 2014 01:21
By: Michel Cadot
  CLOB extraction
Oracle 11g
By: OraFaq13 on Tue, 25 February 2014
5 431 Tue, 25 February 2014 17:23
By: BlackSwan
  Query for the below
By: ramraju20000 on Tue, 25 February 2014
1 283 Tue, 25 February 2014 10:50
By: Michel Cadot
  Column Restriction
Oracle 11g
By: ORAGENASHOK on Tue, 25 February 2014
6 520 Tue, 25 February 2014 09:33
By: BlackSwan
  Putting a WITH statement into PL/SQL
Oracle 11g
By: skbytes on Tue, 25 February 2014
6 538 Tue, 25 February 2014 05:08
By: skbytes
  clob aggregation (merged)
By: rajivn786 on Fri, 09 July 2010
35 2332 Tue, 25 February 2014 02:36
By: subrat_pinku
  Date Typecast Usage
Oracle Database 11g
By: manubatham20 on Mon, 24 February 2014
7 547 Mon, 24 February 2014 21:00
By: BlackSwan
  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 558 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 727 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 768 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 778 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 318 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 559 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 446 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 487 Fri, 21 February 2014 05:06
By: skbytes
  Oracle Partitioning
Oracle 10 G, Windows 7
By: s4.ora on Fri, 21 February 2014
3 343 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 545 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 373 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 410 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 1233 Thu, 20 February 2014 08:55
By: cookiemonster
  Future Partitions
Oracle 11g
By: srinivas.k2005 on Thu, 20 February 2014
2 281 Thu, 20 February 2014 08:23
By: srinivas.k2005
  alias name in where clause
By: anniepeteroracle on Thu, 20 February 2014
5 503 Thu, 20 February 2014 08:20
By: Michel Cadot
  no of counts from case when
By: ashwanth77 on Thu, 20 February 2014
3 489 Thu, 20 February 2014 06:18
By: Michel Cadot
  Procedure.,
By: Rarawshenkiv on Thu, 20 February 2014
5 458 Thu, 20 February 2014 05:56
By: Michel Cadot
  Terrifying result of sql-query, need explanation.
By: Cott on Tue, 18 February 2014
29 1287 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 573 Thu, 20 February 2014 00:25
By: kojot
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 342 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 488 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 944 Wed, 19 February 2014 09:05
By: skbytes
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 24 03:46:20 CDT 2014

Total time taken to generate the page: 0.13025 seconds