Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 your views on oracle views

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-15 : 13:06:29
mani writes "how can i have a view which will say take a parameter
and this parameter will be used by the query in the view
so that we get proper results
example : create view something (somevalue)as
select ord_id from orders where
ord_id = '||somevalue||'

i hope my question is clear

so that in java when i make a select statment from this view
i can say select * from viewname(paramenter)

is there any way to do this


expecting reply

thnx in advance
mani

"
   

- Advertisement -