Design Tuning IBM DB2 MySQL Oracle SQL Server

define schema='schema_name'
create sequence &schema..seqname​
increment by 1
start with 1
nocache;
grant select
on &schema..seqname​
to rolename1,
rolename2;


back to top

Last updated Wednesday March 7, 2007

Printer-friendly PDF* format:

Create Sequence

Oracle DDL

This Section

You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.