摘要：1.在command window窗口中，给特定用户授权：grant select on V_$session to 用户;grant select on V_$sesstat to 用户;grant select on V_$statname to 用户;2.在command window窗口中，将查询视图权限授权给public用户：grant select on v_$statname to public;grant select on v_$session to public;grant select on v_$sesstat to public;3.Tools(工具)-->Pr 阅读全文

摘要：//建测试表createtabledept(deptnonumber(3)primarykey,dnamevarchar2(10),locvarchar2(13));createtableemployee_info(empnonumber(3),deptnonumber(3),enamevarchar2(10),sexchar(1),phonenumber(11),addressvarchar2(50),introducevarchar2(100));--//0.重命名//0.1表:renamedepttodt; renamedttodept;//0.2列:altertabledeptrena 阅读全文