Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle views and function problems
CREATE OR REPLACE VIEW V_ACTUALS AS SELECT substr(lineitem(accnbri), 1, 5)
as line_item,
etc.
dbarker_at_tpgi.com.au wrote in article <6ilvm7$m5l$1_at_nnrp1.dejanews.com>...
> I have created an Oracle function that takes one input VARCHAR parameter
and
> returns a VARCHAR2(5) value. I have created a view that selects records
from
> a table and uses this function. When I perform a DESC on the view the
> function is of type VARCHAR2(2000). Does anybody have any ideas?
> ...
> CREATE OR REPLACE VIEW V_ACTUALS AS SELECT lineitem(accnbri) as
line_item,
> glf_ldg_acct.* FROM glf_ldg_acct
Received on Tue May 05 1998 - 12:20:08 CDT