Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: (Was Stored Procedures) Query/Views etc

Re: (Was Stored Procedures) Query/Views etc

From: Ian Sparkes <sparkes_at_sprintmail.com>
Date: 1997/05/20
Message-ID: <01bc6578$f0a24ae0$748285ce@sprintmail>#1/1

You can pass variables to views by joining the rest of the view with a "parameter table".

Insert the values you want before selecting from the view. In a complex environment you might need to partition the parameter table by username or a sequence #. Received on Tue May 20 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US