create table userinfo(
userid varchar2(10) primary key,
passwd varchar2(12),
Username Varchar2(12),
gender char(1) default 'M' check (gender in ('F', 'M')),
birth date,
email varchar2(50),
address varchar2(100),
phone char(11),
mobile char(11),
Blog Varchar2(50),
Letter Char(1) Default 'N' Check (Letter In('Y','N')),
Sms Char(1) Default 'N' Check (Sms In ('Y','N')),
interest varchar2(100));
Insert Into Userinfo (Userid, Passwd, Username, Birth, Address, Phone, Mobile, Blog) Values
('admin','a1234', '관리자', Sysdate, '경기도, '03112345678','01012345678', 'http://bookshop.com/admin');
commit;
Select * From Userinfo;
jsp와 연결되는 예제 소스.