create table bankuser
(
id int primary key,
name varchar2(30),
password varchar2(30)
);
create table bankcard
(
id int primary key,
id2 int references bankuser(id),
cardcode varchar(30),
cardpassword varchar(30),
money int
);
CREATE SEQUENCE bankuser_id increment by 1;
CREATE SEQUENCE bankcard_id increment by 1;insert into bankuser values(bankuser_id.nextval,'aaaaaa','111111');
insert into bankuser values(bankuser_id.nextval,'bbbbbb','222222');
insert into bankuser values(bankuser_id.nextval,'cccccc','333333');
(
id int primary key,
name varchar2(30),
password varchar2(30)
);
create table bankcard
(
id int primary key,
id2 int references bankuser(id),
cardcode varchar(30),
cardpassword varchar(30),
money int
);
CREATE SEQUENCE bankuser_id increment by 1;
CREATE SEQUENCE bankcard_id increment by 1;insert into bankuser values(bankuser_id.nextval,'aaaaaa','111111');
insert into bankuser values(bankuser_id.nextval,'bbbbbb','222222');
insert into bankuser values(bankuser_id.nextval,'cccccc','333333');
解决方案 »
- 现金求助!关于非规则文本的多文件入库
- 如何判断数据库已经备份完毕?
- 关于oracle 中数据导入中的问题,急!请教!
- oracle自定义类型
- PL/SQL 的包在实际开发中作用大吗?
- 请教为何full=yes导出的dmp文件导入到另外一个服务器的时候没有任何触发器???
- [求助]这个动态 SQL ,为什么执行不了?
- 求一sql查询语句!很急,拜托高手!有关distinct用法的
- ADO与Oracle配合使用,在Oracle SQL Plus出错的语句,在ADO中不出错,奇怪!!!!
- 可不可以用function或是procedure返回多条记录?
- 查询出king所在部门的工作年限最大的员工名字
- PL/SQL 字符处理:“(字符1)保留字符(字符1)”
--是不是这个意思?
insert into bankuser values(bankuser_id.nextval,'aaaaaa','111111');
insert into bankcard values(bankcard_id.nextval,bankuser_id.currval,'code1','cardpassword1',20);
insert into bankuser values(bankuser_id.nextval,'bbbbbb','222222');
insert into bankcard values(bankcard_id.nextval,bankuser_id.currval,'code2','cardpassword2',20);
insert into bankuser values(bankuser_id.nextval,'cccccc','333333');
insert into bankcard values(bankcard_id.nextval,bankuser_id.currval,'code3','cardpassword3',20);