ok.txt

oracle数据库技术oracle数据库技术oracle数据库技术oracle数据库技术oracle数据库技术oracle数据库技术oracle数据库技术

select sysdate from dual;
create table t_user
(
   id   number not null,
   name varchar2(60),
   age  integer,
   primary key (id)
);



select * from t_test;

drop sequence seq_test;

create sequence seq_test increment by 1 start with 1 maxvalue 999999999999 cycle nocache;
create sequence seq_user increment by 1 start with 1 maxvalue 999999999999 cycle nocache;

insert into t_user values(seq_test.nextval,'admin',20);
insert into t_user values(seq_test.nextval,'system',30);
insert into t_user values(seq_test.nextval,'manager',40);
insert into t_user values(seq_test.nextval,'sys',50);

truncate table t_test

alter table t_test add constraint tt unique (name);

alter table t_test cache;
alter table t_test nocache;

drop table t_test cascade constraints;

select * from t_test union select * from t_user;
select * from t_test union all select * from t_user;
select * from t_test minus select * from t_user;
select * from t_test intersect select * from t_user;

create index ind_test on t_test(name);
create index ind_user on t_user(name);

alter index ind_test rebuild;
alter index ind_user rebuild;

create or replace view view_test as select distinct(t.name) from t_test t group by name;
create or replace view view_user as select u.name from t_user u;
alter view view_test compile;
alter view view_user compile;

update view_test set name='dd';
select * from view_user;

create synonym syn_test for t_test;
create synonym syn_user for t_user;

create database link tt connect to soctt identified by tiger using '192.168.1.99:1521:orcl';

select * from global_name;
grant connect,resource to sys;
grant select on t_user to sys;
grant select ,insert ,delete on t_test to sys;
grant connect,resource,dba to sys;

revoke connect,resource from sys;
revoke select on t_user from sys;
revoke select ,insert,delete on t_test from sys;

select name garisy from t_user order by garisy asc;
select name "garisy" from t_user order by name asc;

grant create table to sys;
grant update any table to sys;
grant create session to sys;