Re: doing hints on view

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 :) Received on Thu Feb 07 2008 - 06:54:40 CST