crebas.sql

来自「JDBC连数据库,这是一门很基初的技术,一定要好好研究」· SQL 代码 · 共 14 行

drop table sd0703_account
create table sd0703_account
(
	id number(4),
	no varchar2(18) not null,
	pwd varchar2(15) not null,
	owner varchar2(20) not null,
	balance number(10, 2) not null,
	cdate date,
	primary key(id)
)

insert into sd0703_account(id, no, pwd,owner, balance, cdate)
    values(1, 'account001', 'pwd001', 'user001', 0, to_date('2007-07-17', 'yyyy-mm-dd'))