Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

view with to_number

newbiegalJun 30 2008 — edited Jun 30 2008
Hi,

I am trying to write a view as below:

create or replace force view text_vw (itm,
sile,
eqty,
)

as
select itm,sile,to_number(qty)
from text
where code in (2,3)
order by itm,sile,qty;

In the above view, the qty value in table 'text' is varchar2 and in the text_vw, eqty value should be converted from varchar to numeric.

Please help, with your suggestions. Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2008
Added on Jun 30 2008
9 comments
284 views