Home -> Usenet -> comp.databases.oracle -> Decode question

Decode question

From: Julia Sats <julia_sats_at_sympatico.ca>
Date: Wed, 25 Jun 2003 21:04:03 -0400
Message-ID: <2FrKa.4083$iM4.605358_at_news20.bellglobal.com> 






does exist any chance to do in SQL , without using PL/SQL code like it:



select project_type,


decode (project_type,

1, select count(*) from t1,
2, select count(*) from t2,
3, select count(*) from t3,




0) count_prj


from projects



Thanks
Received on Thu Jun 26 2003 - 03:04:03 CEST












Original text of this message