Home » SQL & PL/SQL » SQL & PL/SQL » Re: Functions and Views
Re: Functions and Views [message #37047] Fri, 11 January 2002 12:47
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
are you talking about oracle view?. or something else?.

you can use this query directly in crystal reports. if you want to create view, use command below.
Create view myview AS
SELECT SUM(TOTAL_AMOUNT) as tot_amt,
BP_PERMIT_FEES.DT_DEVELOPMENT_APPLICATION_ID
FROM BP_PERMIT_FEES
GROUP BY DT_DEVELOPMENT_APPLICATION_ID;

Report message to a moderator

Previous Topic: help with joining quries
Next Topic: Locking rows with For update no wait
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 20 16:20:39 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.