oracle同义词怎么导出,oracle同义词语句备份

--创建同义词

create synonym T_SYSTEM_USERDEPARTMENT for xtzl.T_SYSTEM_USERDEPARTMENT;

--查询同义词

SELECT * FROM SYS.ALL_SYNONYMS WHERE SYNONYM_NAME='T_SYSTEM_POST';

--查询当前用户下的同义词

select * from user_synonyms;

--授权查询

grant select on tabel1 to secmgt

--撤销权限；

revoke insert on T_SYSTEM_USERDEPARTMENT from secmgt;

--查询当前用户下的序列号

select * from user_sequences;

--测试查询

select a.* ,rowid From T_SYSTEM_DEPARTMENT a ;

--删除测试

delete from T_SYSTEM_DEPARTMENT where ID='1';

--测试插入

insert into T_SYSTEM_DEPARTMENT (id,DEPTNAME,parentid,State,Orderno) values (1,'测试部门','0','启用','123');

--删除测试

drop table T_SYSTEM_USERDEPARTMENT;