Re: doing hints on view

Eitan M wrote:
> How can I do instead of using package in my example, use a standard sql.
>
> select
> 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.org