Table creation/Postal addresses: Difference between revisions
Content added Content deleted
No edit summary |
(added Oracle SQL example) |
||
Line 14: | Line 14: | ||
PRIMARY KEY (`addrID`) |
PRIMARY KEY (`addrID`) |
||
); |
); |
||
==[[Oracle SQL]]== |
|||
[[Category:Oracle SQL]] |
|||
CREATE SEQUENCE seq_address_pk START BY 100 INCREMENT BY 1 |
|||
/ |
|||
CREATE TABLE address ( |
|||
addrID NUMBER DEFAULT seq_address_pk.nextval, |
|||
street VARCHAR2( 50 ) NOT NULL, |
|||
city VARCHAR2( 25 ) NOT NULL, |
|||
state VARCHAR2( 2 ) NOT NULL, |
|||
zip VARCHAR2( 20 ) NOT NULL, |
|||
CONSTRAINT address_pk1 PRIMARY KEY ( addrID ) |
|||
) |
|||
/ |
|||
==[[PostgreSQL]]== |
==[[PostgreSQL]]== |
Revision as of 22:27, 24 January 2007
![Task](http://static.miraheze.org/rosettacodewiki/thumb/b/ba/Rcode-button-task-crushed.png/64px-Rcode-button-task-crushed.png)
You are encouraged to solve this task according to the task description, using any language you may know.
In this task, the goal is to create a table to store addresses.
MySQL
CREATE TABLE `Address` ( `addrID` int(11) NOT NULL auto_increment, `addrStreet` varchar(50) NOT NULL default , `addrCity` varchar(25) NOT NULL default , `addrState` char(2) NOT NULL default , `addrZIP` char(10) NOT NULL default , PRIMARY KEY (`addrID`) );
Oracle SQL
CREATE SEQUENCE seq_address_pk START BY 100 INCREMENT BY 1 / CREATE TABLE address ( addrID NUMBER DEFAULT seq_address_pk.nextval, street VARCHAR2( 50 ) NOT NULL, city VARCHAR2( 25 ) NOT NULL, state VARCHAR2( 2 ) NOT NULL, zip VARCHAR2( 20 ) NOT NULL, CONSTRAINT address_pk1 PRIMARY KEY ( addrID ) ) /
PostgreSQL
CREATE SEQUENCE address_seq start 100; CREATE TABLE address ( addrID int4 PRIMARY KEY DEFAULT nextval('address_seq'), street varchar(50) not null, city varchar(25) not null, state varchar(2) not null, zip varchar(20) not null );
SAS
DATA address; LENGTH addrID 8. street 50$ city 25$ state 2$ zip 20$; STOP; RUN;
UDB DB2
CREATE TABLE Address ( addrID Integer generated by default as identity, addrStreet Varchar(50) not null, addrCity Varchar(25) not null, addrState Char(2) not null, addrZIP Char(10) not null )