OraFAQ Forum: SQL & PL/SQL » Re: define view column as a PL/SQL functon

Home » SQL & PL/SQL » SQL & PL/SQL » Re: define view column as a PL/SQL functon

Mon, 10 June 2002 22:28

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Yes, it shouldn't be a problem, as long as the function only uses SQL datatypes.

create view v_test
    as
select item_id
     , repcat_test.fun$storage(item_id) fun_column
  from repcat.items
/

MHE

Previous Topic:	Pl/Sql
Next Topic:	how to identify only a non numeric data

Goto Forum:

]

Current Time: Mon May 20 13:15:50 CDT 2024