Re: doing hints on view
Date: Thu, 07 Feb 2008 09:19:54 -0800
Eitan M wrote:
> How can I do instead of using package in my example, use a standard sql.
> t.column_1, t.column_2,
> t2.name , ...
> where t2.name = t.
> my_package.my_func(t.column_1, '2') ...
> from my_table t, my_table2 t2
> where t2.name = t.name || ' - 1' (*)
> the (*) doesn't work.
> What should I do instead ?
> Thanks :)
You should never use "*" for anything in production code so rather than asking us how to make bad code work how about describing the business problem you are trying to address.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Feb 07 2008 - 11:19:54 CST