oracle技.docVIP

(原创)在oracle数据库中些sql语句技巧 关键词： oracle ?? ?????????????????????????????????????? 创建一个表引用另一个表create table testbeifen as select * from test创建索引create index testindex on test(a,b)重命名表 rename test to testtemp;查看当前用户所有表的大小Select Segment_Name,Sum(bytes)/1024/1024 From User_Extents Group By Segment_Name 模糊查询select * from test2 where PRODUCTNAME like %%查某个字段是否为空:select b.GUEST_NAME from dbreports a,YSKYJ_YSZK_TABLE b where a.id=b.fileid and GUEST_CODE is null查行不重复的?select distinct job from emp;按两个字段分组查select a.UNITCODE,b.PRODUCT_CODE,sum(b.ZP_QD),sum(b.ZP_ZD) from DBREPORTS a,QDKU_ZP_TABLE