OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
how to make it by help of procedure By: aaditya321 on Wed, 26 February 2014	3	338	Wed, 26 February 2014 01:21 By: Michel Cadot
CLOB extraction Oracle 11g By: OraFaq13 on Tue, 25 February 2014	5	298	Tue, 25 February 2014 17:23 By: BlackSwan
Query for the below By: ramraju20000 on Tue, 25 February 2014	1	166	Tue, 25 February 2014 10:50 By: Michel Cadot
Column Restriction Oracle 11g By: ORAGENASHOK on Tue, 25 February 2014	6	427	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	451	Tue, 25 February 2014 05:08 By: skbytes
clob aggregation (merged) By: rajivn786 on Fri, 09 July 2010	35	2054	Tue, 25 February 2014 02:36 By: subrat_pinku
Date Typecast Usage Oracle Database 11g By: manubatham20 on Mon, 24 February 2014	7	441	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	429	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	642	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	626	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	10	647	Sat, 22 February 2014 00:18 By: Michel Cadot
Performance impact by using Number/Char column as primary key 11g, AIX By: harpreetsinghkup on Fri, 21 February 2014	4	155	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	420	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	319	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	5	391	Fri, 21 February 2014 05:06 By: skbytes
Oracle Partitioning Oracle 10 G, Windows 7 By: s4.ora on Fri, 21 February 2014	3	261	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	439	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	289	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	247	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	1066	Thu, 20 February 2014 08:55 By: cookiemonster
Future Partitions Oracle 11g By: srinivas.k2005 on Thu, 20 February 2014	2	210	Thu, 20 February 2014 08:23 By: srinivas.k2005
alias name in where clause By: anniepeteroracle on Thu, 20 February 2014	6	405	Thu, 20 February 2014 08:20 By: Michel Cadot
no of counts from case when By: ashwanth77 on Thu, 20 February 2014	7	391	Thu, 20 February 2014 06:53 By: msol25
Sys_refcursor By: Rarawshenkiv on Thu, 20 February 2014	1	152	Thu, 20 February 2014 06:46 By: msol25
Procedure., By: Rarawshenkiv on Thu, 20 February 2014	6	366	Thu, 20 February 2014 05:56 By: Michel Cadot
Terrifying result of sql-query, need explanation. By: Cott on Tue, 18 February 2014	29	1176	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	377	Thu, 20 February 2014 00:25 By: kojot
SELECT INTO causes ORA-00905 Error By: Uncle_Jake on Wed, 19 February 2014	2	235	Wed, 19 February 2014 13:29 By: John Watson
pls help in query pl sql By: simplesanju on Wed, 19 February 2014	2	233	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	362	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	835	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	241	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	474	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	242	Wed, 19 February 2014 00:53 By: Michel Cadot
Struggling with DBMS_JOB.SUBMIT syntax 11g By: bristolsmithy on Tue, 18 February 2014	3	293	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	218	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	289	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	385	Tue, 18 February 2014 11:07 By: BlackSwan
First Character in "numeric-Alpha" 10.2.0 By: bluetooth420 on Mon, 10 February 2014	9	479	Tue, 18 February 2014 07:03 By: cookiemonster
Oracle Compare 2 Tables 11g By: developer12 on Tue, 18 February 2014	1	152	Tue, 18 February 2014 05:54 By: Michel Cadot