create sequence Onum start with 1000

select '***** Order number is ----->' ||rtrim(Onum.Nextval)||'' from dual


create table OrderDetail (Onum number(8,0),
Odate date,
Rdate date,
Eonum varchar2(3),
Ernum varchar2(3),
Inum number(3,0),
Spnum number(3,0),
Orderqty number(10,0),
Unitprice number(5,2),
Amtdue number(7,2),
Orderstatus varchar2(12))

insert into OrderDetail (Onum, Odate, Eonum, Inum, Spnum, Orderqty, Unitprice, Amtdue, Orderstatus)
select (Onum.Nextval), sysdate, '&vEmnum', '&vInum', '&vSpnum', '&vOrderqty', 10, (10*'&vOrderqty'), 'Open' 
from dual

select * from orderdetail