insert into orders (oid, orddate, cid, pid, quantity)

select maxnum, sysdate, '&vCid', '&vPid', '&vquantity' from counter;