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
  dbms_output.put_line
oracle11g/r2/unix
By: balaji123 on Tue, 04 March 2014
2 343 Tue, 04 March 2014 02:09
By: John Watson
  Rollup using with UNION
By: zsiddiquis on Mon, 03 March 2014
6 556 Mon, 03 March 2014 12:01
By: Michel Cadot
  Index on column name "number"!!!
By: vulcanjibe on Fri, 28 February 2014
7 757 Sat, 01 March 2014 11:29
By: vulcanjibe
icon4.gif SQL - QUERY
By: vippysharma on Fri, 28 February 2014
8 878 Sat, 01 March 2014 09:53
By: Michel Cadot
  Get previous quarter value
By: Bluebeam on Fri, 28 February 2014
1 225 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 284 Fri, 28 February 2014 09:59
By: BlackSwan
  sql execution
oracle 11g/r2 unix
By: balaji123 on Fri, 28 February 2014
3 270 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 581 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 1008 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 2571 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 466 Thu, 27 February 2014 07:18
By: Solomon Yakobson
  DDL and DML
By: deepak439 on Wed, 26 February 2014
2 267 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 489 Wed, 26 February 2014 22:26
By: ken002
  how to make it by help of procedure
By: aaditya321 on Wed, 26 February 2014
3 410 Wed, 26 February 2014 01:21
By: Michel Cadot
  CLOB extraction
Oracle 11g
By: OraFaq13 on Tue, 25 February 2014
5 464 Tue, 25 February 2014 17:23
By: BlackSwan
  Query for the below
By: ramraju20000 on Tue, 25 February 2014
1 314 Tue, 25 February 2014 10:50
By: Michel Cadot
  Column Restriction
Oracle 11g
By: ORAGENASHOK on Tue, 25 February 2014
6 547 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 568 Tue, 25 February 2014 05:08
By: skbytes
  clob aggregation (merged)
By: rajivn786 on Fri, 09 July 2010
35 2472 Tue, 25 February 2014 02:36
By: subrat_pinku
  Date Typecast Usage
Oracle Database 11g
By: manubatham20 on Mon, 24 February 2014
7 566 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 584 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 759 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 813 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 820 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 345 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 594 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 488 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 519 Fri, 21 February 2014 05:06
By: skbytes
  Oracle Partitioning
Oracle 10 G, Windows 7
By: s4.ora on Fri, 21 February 2014
3 365 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 571 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 397 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 442 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 1259 Thu, 20 February 2014 08:55
By: cookiemonster
  Future Partitions
Oracle 11g
By: srinivas.k2005 on Thu, 20 February 2014
2 300 Thu, 20 February 2014 08:23
By: srinivas.k2005
  alias name in where clause
By: anniepeteroracle on Thu, 20 February 2014
5 532 Thu, 20 February 2014 08:20
By: Michel Cadot
  no of counts from case when
By: ashwanth77 on Thu, 20 February 2014
3 521 Thu, 20 February 2014 06:18
By: Michel Cadot
  Procedure.,
By: Rarawshenkiv on Thu, 20 February 2014
5 482 Thu, 20 February 2014 05:56
By: Michel Cadot
  Terrifying result of sql-query, need explanation.
By: Cott on Tue, 18 February 2014
29 1323 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 603 Thu, 20 February 2014 00:25
By: kojot
  SELECT INTO causes ORA-00905 Error
By: Uncle_Jake on Wed, 19 February 2014
2 374 Wed, 19 February 2014 13:29
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: Sat Aug 30 21:29:28 CDT 2014

Total time taken to generate the page: 0.09892 seconds