RE: Need assistance with a 'VIEW'.

Hi,
Someone posted the past week the solution of something like that.

He referred to create package and pass the date as a parameter to it and have a procedure, inside the package, that create the view using the parameter date.

That what I can recall.

Good luck,

Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> 809-565-3121

-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de William Rogge Enviado el: Tuesday, 18 September, 2001 10:47 AM Para: Multiple recipients of list ORACLE-L Asunto: Need assistance with a 'VIEW'.

I have been given the nice task of creating a view of some data in our database.

This doesn't seem like a major task, but after 2 days of work, I am stumped.

Given table 'table1'

   code1,
   code2,
   date,
   value1,
   value2

I need to produce a view showing

   code1,
   code2,
   sum(value1),
   sum(value2)
  where date < 'user input date'

I have not been able to get the view to prompt for the date to limit the sum by.

Specifics:
  Oracle RDMBS 7.3.4
  Server: Unix

What else can I say, but I am totally stumped. HELP!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Rogge
  INET: William_Rogge_at_voltek.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon Estevez
  INET: com.banilejas_at_codetel.net.do

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).