select * from user_tables
create table t_user(
id number not null primary key,
name varchar(10),
age number(3),
rmark varchar (59)
)
drop sequence sqe_s
create sequence sqe_s
start with 1
increment by 1
minvalue 1
maxvalue 9999999;
insert into t_user values (sqe_s.nextval,'name',131,'rmark');
commit;
select * from T_user
create view vi_user
as
select t.id as id, t.name as 姓名,t.age as 年龄, t. rmark as 备注 from T_user t;
drop view vi_user
select * from vi_user
create or replace procedure pp (in number a)
begin
insert into t_user values (sqe_s.nextval,'name',a,'rmark');
end;
declare
a number;
begin
a:=10;
pp(a);
end;
begin
pp(411);
end;
select * from t_user where age > (select avg(age) from t_user)
select sum(age) from t_user
select to_date('2013-01-01','yyyy-mm-dd') from t_user
create or replace trigger tri_my
after
insert on t_user
begin
update T_user set age=99 where age>100;
end;
create or replace trigger tri_my
before
insert or update of on t_user
begin
update T_user set age=99 where age>100;
end;
create table r_user as select * from t_user where age<10
insert into r_user select * from t_user where age>10
数据库面试题
最新推荐文章于 2020-03-10 17:20:40 发布