|
- select table_name from user_tables order by 1 desc ;
- create table t05110_t ( a number ) ;
- alter table t05110_t add (b varchar2(20) , c date );
- alter table t05110_t modify (c number ) ;
- insert into t05110_t values ( 1, 'A', 10) ;
- ---alter table t05110_t modify (c varchar2(20)) ;
- alter table t05110_t modify (b char(21)) ;
- --------------------------
- alter table t05110_t drop column b;
- alter table t05110_t add ( b number , d number , e number ) ;
- select * from t05110_t;
- alter table t05110_t drop ( a,e ) ;
-
- select * from t05110_t;
- --------
- alter table t05110_t set unused column c ;
- ----
- select * from dict where table_name like '%UNUSED%';
- select * from user_unused_col_tabs;
- ---
- alter table t05110_t drop unused columns;
- -----
- alter table t05110_t rename column b to bb;
- -----
- rename t05110_t to t05110_t1;
- select * from t05110_t1;
- alter table t05110_t1 read only;
- insert into t05110_t1 values (1,11);
- alter table t05110_t1 read write;
- insert into t05110_t1 values (1,11);
- -----
复制代码
- create or replace view v1 as
- select e.employee_id, e.last_name, e.email, e.department_id , d.department_name
- from employees e, departments d
- where e.department_id=d.department_id order by 1;
-
- select * from v1;
-
- update v1 set email='XXX' where email='SKING';
-
-
- update v1 set department_id=60 where employee_id=100;
-
- update v1 set department_name='YYY' where email='XXX';
-
- create table t05111_a ( a number ) ;
-
- create view v2 as select a*2 b from t05111_a;
-
- insert into t05111_a values (8) ;
-
- select * from v2;
-
- update v2 set b=10 ;
- ---
- CREATE or replace VIEW empvu80
- AS SELECT employee_id, last_name, salary , department_id
- FROM employees
- WHERE department_id = 80 order by employee_id
- with check option constraint v2_chk;
- ----
- select * from empvu80;
- update empvu80 set department_id=60 where employee_id=145;
- select * from user_constraints order by table_name;
- update empvu80 set department_id=60 where employee_id=146;
复制代码- select * from seq[ DISCUZ_CODE_5 ]nbsp; order by 1 desc;
- select * from dba_sequences s where s.sequence_owner='HR'
- and s.sequence_name like 'SEQ%';
复制代码
|
|