SQL
-
编辑 删除
ORCLE 数据库中一些常用的表
1. DBA_TAB_PRIVS -- 用来查询那些数据库账号对某个表有什么权限。select * from dba_tab_privs where privilege = 'DELETE' and table_name IN ( 'XXAP_JFI_SUPPLIERS','XXAP_JFI_SUPPLIER_SITES',)AND GRANTEE ='JASON_SU'2. ALL_DEPENDENCIES --这个表厉害了，可以查一...
-
编辑 删除
Some common query which i used in my work
BEGIN DBMS_APPLICATION_INFO.set_client_info (<OU ID>); END; BEGIN fnd_global.apps_initialize(<v_num_user_id>, &nb...
