You Can Get Logged User IP Address Using This SQL : "select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual" You Can Get Machine Name Using :declare 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 accessRead more
You Can Get Logged User IP Address Using This SQL :
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
You Can Get Machine Name Using :declare 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;
I Still need to know how to get logged user mac address
You Can Get Logged User IP Address Using This SQL : "select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual" You Can Get Machine Name Using :declare 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 accessRead more
You Can Get Logged User IP Address Using This SQL :
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
You Can Get Machine Name Using :declare 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;
I Still need to know how to get logged user mac address
You Can Get Logged User IP Address Using This SQL : "select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual" You Can Get Machine Name Using :declare 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 accessRead more
You Can Get Logged User IP Address Using This SQL :
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
You Can Get Machine Name Using :declare 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;
I Still need to know how to get logged user mac address
Get Mac Address of Machine Network
Mohamed Younis
You Can Get Logged User IP Address Using This SQL : "select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual" You Can Get Machine Name Using :declare 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 accessRead more
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
- You Can Get Machine Name Using :declare
- I Still need to know how to get logged user mac address
See lessme 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;
MAC Address Restriction in oracle apex
Mohamed Younis
You Can Get Logged User IP Address Using This SQL : "select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual" You Can Get Machine Name Using :declare 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 accessRead more
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
- You Can Get Machine Name Using :declare
- I Still need to know how to get logged user mac address
See lessme 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;
How To Get Computer IP Address , Computer Name And MAC Address
Mohamed Younis
You Can Get Logged User IP Address Using This SQL : "select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual" You Can Get Machine Name Using :declare 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 accessRead more
"select owa_util.get_cgi_env('REMOTE_ADDR') AS IP_Adress from dual"
- You Can Get Machine Name Using :declare
- I Still need to know how to get logged user mac address
See lessme 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;