|
-
Chris!!
Why going for pl/sql?
Hope the following would work well.
Try it.
-----------------------------------------------------------
Select decode(count(acntid),0,'No Record','Some Records'),
sum(amount) from deal where acntid=9834;
-----------------------------------------------------------
Raja.M
[email protected]
Last edited by spbraja; 05-03-2003 at 07:45 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote