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;
Previous Topic: help with joining quries
Next Topic: Locking rows with For update no wait
Goto Forum:
  


Current Time: Fri Mar 29 22:15:44 CDT 2024