随笔分类 -  oracle

摘要：不多说，直接上干货 1、查询当前用户下表的创建语句 select dbms_metadata.get_ddl('TABLE','ux_future') from dual; 2、查询其他用户下表的创建语句 select dbms_metadata.get_ddl('TABLE','ux_future 阅读全文

摘要：创建表:create table t1(key1 type default 0,key2 type not null) 删除表:drop table t1; 删除表数据:truncate table t1; 增加列:alter table t1 add f3 type; 删除列:alter tabl 阅读全文

摘要：创建用户:create user usr1 identified by pwd default tablespace ts1 temporary tablespace tmp; 删除用户:drop user usr1 casecade; 阅读全文

摘要：普通查询:select * from t; 去除重复值:select distinct f1,f2 from t; between用法:select * from t where f1 not/between 1and 2; like用法:select * from t where f1 not/l 阅读全文