Serial Numbers

Setup

Run the code on this page in SQL*Plus to create the sample tables, data, etc. used by the examples in this section.

Be sure to read Using SQL Snippets ™ before executing any of these setup steps.

create table t
( key           number ,
  name          varchar2(5) ,
  serial_number number
);

create table t2
( key           number ,
  name          varchar2(5) ,
  status        varchar2(10) ,
  serial_number number
);

create sequence ts start with 1001 ;
 



Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

  • [url=http://www.sqlsnippets.com/en/topic-11876.html]SQL Snippets: Serial Numbers - Setup[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

  • <a href="http://www.sqlsnippets.com/en/topic-11876.html">SQL Snippets: Serial Numbers - Setup</a>

To link to this page in other web sites use the following values.

  • Link Text : SQL Snippets: Serial Numbers - Setup
  • URL (href): http://www.sqlsnippets.com/en/topic-11876.html