-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|