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
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
trigger raised unhandled exception Oracle 10g (Oracle forms Builder) By: raplee on Sat, 27 April 2013	10	500	Sun, 28 April 2013 14:23 By: Littlefoot
Required SQL Query Output. 11g By: ranamirfan on Sun, 28 April 2013	6	339	Sun, 28 April 2013 10:41 By: Solomon Yakobson
joining two tables oracle 11g By: mariomario89 on Fri, 26 April 2013	11	466	Sat, 27 April 2013 04:37 By: dariyoosh
how to debug package By: reenasharma on Sat, 20 April 2013	6	349	Fri, 26 April 2013 09:14 By: Michel Cadot
adding number in sysdate Oracle 11g By: ashwani0301 on Fri, 26 April 2013	5	310	Fri, 26 April 2013 09:05 By: Michel Cadot
function returning pl/sql table of dynamic structure oracle 11g By: rkkrk2 on Wed, 24 April 2013	12	458	Fri, 26 April 2013 07:13 By: Solomon Yakobson
how to execute the type variable procedure. Oracle 11g By: ajaykumarkona on Fri, 26 April 2013	2	227	Fri, 26 April 2013 03:56 By: sss111ind
Creating custom error message Oracle 10g By: konvictx on Wed, 24 April 2013	12	435	Thu, 25 April 2013 23:59 By: Barbara Boehmer
FIFO Store Consumption Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Thu, 25 April 2013	5	209	Thu, 25 April 2013 23:22 By: mmohsinaziz
DBMS_SQL.describe_columns2-session disconnect oracl 10g By: shiva_blr on Tue, 23 April 2013	7	275	Thu, 25 April 2013 17:44 By: Barbara Boehmer
Merge is not working properly Oracle 11g By: ajaykumarkona on Tue, 23 April 2013	12	436	Thu, 25 April 2013 16:40 By: Barbara Boehmer
Complex batch allocation logic + summary of alternate rows [2 merged by jd] Oracle 10g By: arif_md2009 on Sat, 06 April 2013	34	1820	Thu, 25 April 2013 15:51 By: arif_md2009
Hierarical query 9i By: glmjoy on Thu, 25 April 2013	3	246	Thu, 25 April 2013 07:06 By: glmjoy
difference between oracle 9i and 10g By: pankajdurve on Thu, 25 April 2013	1	180	Thu, 25 April 2013 03:05 By: Michel Cadot
Tablespace SQL By: RCaballero1 on Wed, 24 April 2013	5	201	Thu, 25 April 2013 02:25 By: ashwani0301
Compilation Error in Procedure By: agr.mudit on Thu, 25 April 2013	3	151	Thu, 25 April 2013 01:01 By: flyboy
Display conditional column values 10.2.0.4.0 By: lott42 on Tue, 23 April 2013	6	322	Wed, 24 April 2013 09:38 By: lott42
best way to send an email in oracle Oracle 10g By: sss111ind on Wed, 24 April 2013	6	414	Wed, 24 April 2013 07:07 By: Michel Cadot
How to use a function oracle 11g By: ApacheOmega on Tue, 23 April 2013	6	302	Wed, 24 April 2013 03:34 By: ThomasG
Handeling special charater '&' in oracle stored procedure Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: averion on Tue, 23 April 2013	8	226	Tue, 23 April 2013 10:29 By: Michel Cadot
what is error in below code? By: pankajdurve on Tue, 23 April 2013	3	209	Tue, 23 April 2013 06:24 By: Michel Cadot
How to get the total number of occurrences based on the value of a column. By: caloy007 on Sat, 20 April 2013	2	379	Tue, 23 April 2013 04:01 By: Barbara Boehmer
email on job start/complete oracle 10g,xp By: ashwanth77 on Tue, 23 April 2013	4	205	Tue, 23 April 2013 02:56 By: Michel Cadot
how to populate a distinct column in a table oracle 11.g By: ApacheOmega on Mon, 22 April 2013	3	345	Tue, 23 April 2013 00:32 By: Michel Cadot
show number of days between two date By: hassan08 on Thu, 18 April 2013	13	593	Tue, 23 April 2013 00:30 By: Michel Cadot
how to know partticular user existed or not in datbase? oracle 11g By: mailtoyvkr@gmail.com on Mon, 22 April 2013	8	450	Mon, 22 April 2013 23:07 By: arif_md2009
how to list all tables that are connected to each other with constraints and list them all together oracle 11g By: ApacheOmega on Mon, 22 April 2013	2	254	Mon, 22 April 2013 23:05 By: arif_md2009
Please help me! By: suryamm on Mon, 22 April 2013	13	473	Mon, 22 April 2013 06:09 By: suryamm
Deducing rows Oracle 9i R2 By: Amine on Sun, 21 April 2013	4	448	Mon, 22 April 2013 03:42 By: Amine
how to find last or latest inserted row.? By: srikanth_d5 on Mon, 22 April 2013	1	347	Mon, 22 April 2013 01:53 By: John Watson
Simple updation failed ? Reason ? Oracle 10.2 By: bluetooth420 on Sun, 21 April 2013	3	241	Sun, 21 April 2013 10:35 By: Michel Cadot
Separate Index and tables in two different tablespace By: janak_patel85@yahoo.com on Sun, 14 April 2013	2	426	Sat, 20 April 2013 23:45 By: chaopauljun
String sorting Oracle 10g By: himang on Mon, 04 August 2008	26	2317	Sat, 20 April 2013 09:34 By: sss111ind
query to find the number of alphabets TOAD By: bhawnakaamra on Sat, 20 April 2013	6	420	Sat, 20 April 2013 06:35 By: Michel Cadot
how to show total number of department By: pankajdurve on Fri, 19 April 2013	2	164	Fri, 19 April 2013 09:02 By: Michel Cadot
How to Delete files from EXT Table Dir through SQL PLUS Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: sulabhagra on Fri, 19 April 2013	4	182	Fri, 19 April 2013 08:26 By: sulabhagra