you can use the cast function: cast( rownum AS NUMBER(10)) as row_id
create or replace view tvv as select cast( rownum AS NUMBER(10)) as row_id from all_objects where rownum < 10;> desc tvv Name Null? Typ ----------------- -------- ------------ ROW_ID NUMBER(10)