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

Home -> Community -> Usenet -> c.d.o.server -> Re: parameterized views

Re: parameterized views

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 10 Aug 2004 10:02:18 -0400
Message-ID: <b9udnSI6eIxDSIXcRVn-qw@comcast.com> 






"Ernest Morariu" <ernest_at_gesora.com> wrote in message
news:cfaj7g$71r$1_at_fata.cs.interbusiness.it...


| Hi !

|

| Is it possible in Oracle to create a parameterized view ?

|

| ernest

|

|




yes, by referencing a package variable (or function) in the where clause,
and setting the package variable (or populating appropriate rows in control
tables) prior to SELECTing from the view



++ mcs
Received on Tue Aug 10 2004 - 09:02:18 CDT












Original text of this message













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