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
plsql trigger oracle 10g By: pankajdurve on Tue, 07 May 2013	2	295	Tue, 07 May 2013 12:33 By: Michel Cadot
Difference between Concat function and "\|\|" operator 11g, Unix By: harpreetsinghkup on Mon, 06 May 2013	5	471	Tue, 07 May 2013 07:57 By: Bill B
Dynamic Resultset for linear growing columns in a table Oracle 10g, Redhat Linux By: lakksv on Tue, 07 May 2013	1	230	Tue, 07 May 2013 07:57 By: cookiemonster
help in this guyz (merged 3) By: mariappanvijayan on Tue, 07 May 2013	9	715	Tue, 07 May 2013 06:08 By: Michel Cadot
Display result of sql on PL-SQL For loop Oracle 11.2.0.3,Linux x86_64 By: preet_kumar on Tue, 07 May 2013	3	327	Tue, 07 May 2013 06:05 By: sss111ind
Using VArray For Known Column Names? Database 11g Version 11.2.0.1.0 By: Kevin58 on Thu, 02 May 2013	9	389	Mon, 06 May 2013 13:45 By: Kevin58
Problem in Recursive Table Query By: irfankundi786@yahoo.com on Sun, 05 May 2013	12	817	Mon, 06 May 2013 12:31 By: Michel Cadot
Help needed to resolve this critical issue very complex Oracle 10g By: arif_md2009 on Mon, 06 May 2013	0	775	Mon, 06 May 2013 04:36 By: arif_md2009
Generating "time taken" data at row level Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi By: arunkumarsd on Wed, 01 May 2013	6	520	Mon, 06 May 2013 00:02 By: Michel Cadot
Compilation Error in Procedure Oracle 9i By: Asaha5 on Sun, 05 May 2013	5	358	Sun, 05 May 2013 13:06 By: cookiemonster
Query Help using Analytical functions By: vikram1780 on Thu, 02 May 2013	5	365	Sun, 05 May 2013 08:42 By: Amine
Different updates in Plsql Oracle 10g By: sss111ind on Sat, 04 May 2013	3	276	Sat, 04 May 2013 08:52 By: Solomon Yakobson
Update Display Name via SQL Oracle 11g DB By: SurenSingh9192 on Fri, 03 May 2013	12	398	Sat, 04 May 2013 06:23 By: Solomon Yakobson
Sending table data in HTML format through PL/SQL Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production By: NewLife on Fri, 11 July 2008	12	3409	Sat, 04 May 2013 03:33 By: sss111ind
merge two tables in to one and knock out the duplicate records. By: navenkat on Wed, 12 July 2006	4	3535	Fri, 03 May 2013 18:11 By: wbovard
Insert/Delete or do nothing 10.2.0.4.0 By: lott42 on Thu, 18 April 2013	20	548	Fri, 03 May 2013 13:08 By: Michel Cadot
SP2-0027: Input is too long (> 2499 characters) 11.2.0.2 on Solaris 10 By: nirav_hyd on Fri, 03 May 2013	3	178	Fri, 03 May 2013 12:50 By: nirav_hyd
Need Help with After Trigger Oracle 11g, windows 7 By: Bazil on Thu, 02 May 2013	8	282	Fri, 03 May 2013 08:59 By: Bill B
Select data from 2 tables and insert into another table By: DianaPersaud on Thu, 25 April 2013	6	542	Fri, 03 May 2013 08:00 By: pointers
Please help me to tune these procedures Oracle 11g By: ajaykumarkona on Mon, 22 April 2013	7	570	Fri, 03 May 2013 07:50 By: pointers
Need Help Oon SQL 10g By: supiash on Fri, 03 May 2013	5	210	Fri, 03 May 2013 07:47 By: joy_division
Please check new logic is correct. Oracle 11g By: ajaykumarkona on Fri, 03 May 2013	1	167	Fri, 03 May 2013 02:35 By: cookiemonster
sys ref cursor 11g By: xpact83 on Mon, 29 April 2013	35	690	Thu, 02 May 2013 18:33 By: xpact83
Historicize information without writing/certain time [merged 2 by jd] Oracle 9i R2 By: Amine on Wed, 01 May 2013	9	317	Thu, 02 May 2013 13:03 By: Amine
trigger updation By: ramanaapps on Thu, 02 May 2013	4	250	Thu, 02 May 2013 12:04 By: Littlefoot
Convert query to a rolling average Oracle PL SQL By: mxfrail on Thu, 02 May 2013	3	209	Thu, 02 May 2013 11:36 By: Michel Cadot
Trigger from multiple tables Oracle SQL Developer version 2.1.1.64 By: direlan on Wed, 01 May 2013	8	306	Thu, 02 May 2013 00:28 By: Michel Cadot
unwanted result in a join query in oracle ORACLE, 11g,ubuntu By: idb65 on Wed, 01 May 2013	5	229	Wed, 01 May 2013 19:51 By: xpact83
writing a join in oracle sql ORACLE, 11g,ubuntu By: idb65 on Wed, 01 May 2013	12	234	Wed, 01 May 2013 14:40 By: Littlefoot
data looks awkward oracle10gr2 By: guddu_12 on Wed, 01 May 2013	1	193	Wed, 01 May 2013 13:32 By: Michel Cadot
By Default Buffer Size By: janak_patel85@yahoo.com on Tue, 30 April 2013	4	258	Wed, 01 May 2013 10:40 By: Littlefoot
Please correct my SQL By: AviatoR on Tue, 30 April 2013	3	343	Wed, 01 May 2013 06:45 By: Michel Cadot
What is the difference between these two variables Oracle 11g By: ajaykumarkona on Wed, 01 May 2013	2	205	Wed, 01 May 2013 05:46 By: Michel Cadot
Problem in Database trigger 10g By: emadnabil on Tue, 30 April 2013	2	307	Tue, 30 April 2013 12:32 By: dariyoosh
Searching the data in the back up tables oralce 10g By: nareshvictory on Tue, 30 April 2013	7	252	Tue, 30 April 2013 09:04 By: cookiemonster
Please help me to change the logic. Oracle 11g By: ajaykumarkona on Thu, 25 April 2013	10	467	Tue, 30 April 2013 06:24 By: cookiemonster
Unique constraint v/s Distinct 11 g, Unix By: harpreetsinghkup on Tue, 30 April 2013	3	452	Tue, 30 April 2013 05:55 By: Michel Cadot
Indexing on subset of the record. Oracle 10g , Windows server By: saket_kumar on Sun, 28 April 2013	5	383	Tue, 30 April 2013 04:57 By: rleishman
Need SQL Query. Oracle ,11g Release 2, XP: By: cvbharathi89 on Mon, 29 April 2013	11	416	Tue, 30 April 2013 04:56 By: cvbharathi89
table comparision By: ramanaapps on Mon, 29 April 2013	11	305	Mon, 29 April 2013 03:35 By: Roachcoach