pointbase.createsimplebank.sql

来自「一个java写的加密算法」· SQL 代码 · 共 16 行

drop table customer1;

create table customer1 (
  SSN varchar2(9), 
  lastNAme varchar2(20), 
  firstname varchar2(20), 
  address1 varchar2 (20), 
  address2 varchar2(20), 
  city varchar2(10), 
  state varchar2(10), 
  zipcode varchar2(5), 
  balance decimal(10,2) );

insert into customer1 values ('123456789', 'Smith', 'Rob', '1111', 'First Street', 'San Jose', 'CA', '12345', 123);