HOW TO GENERATE SERIAL NUMBERS USING
SQL STATEMENT WITHOUT USING PL/SQL.??
Create a sequence. A sequence is a database object, like a table. However, the sequence's only job is to produce unique numbers when queried:
create sequence myseq;
select myseq.nextval from dual;
Read up on sequences - this is a VERY limited description.
Oracle DBA and Developer