Is there any way to get Network Mac Address where databases is installed.
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
me varchar2(25);
me2 varchar2(100);
no_pc exception; -- In the event the host name is not there
no_acl exception; -- In the event the access is denied
pragma exception_init(no_pc, -29257);
pragma exception_init(no_acl, -24247);
begin
select owa_util.get_cgi_env('REMOTE_ADDR') into me from dual;
SELECT utl_inaddr.get_host_name(me) into me2 FROM dual;
return UPPER(substr(me2, 1, (instr(me2, '.') - 1)));
exception
when no_pc then
null;
when no_acl then
null;
end;