Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
Tuesday, September 19, 2017
User log on and log off history in oracle database on oracle forms 10
http://www.orafaq.com/wiki/Forms_FAQ
create table logon_off_hist
(
user_id varchar2(6),
machine_ip varchar2(50),
machine_nm varchar2(64),
module_nm varchar2(30),
dt date default to_char(sysdate,'DD-MON-RR'),
logon_off_time varchar2(20) default to_char(sysdate,'DD-MON-RR HH24:MI:SS'),
st varchar2(1)
)
///
--logon button
DECLARE
machine_ip varchar2(50);
machine_nm varchar2(64);
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') into machine_ip FROM dual;
select distinct TERMINAL into machine_nm from v$session where USERNAME='ITS'; -- MACHINE
INSERT INTO logon_off_hist(user_id,machine_ip,machine_nm, module_nm,st)
VALUES (:user_id,machine_ip,machine_nm,'ITS','I');
COMMIT_FORM;
clear_message;
END;
/
--key_exit trigger/exit button login form two path
DECLARE
machine_ip varchar2(50);
machine_nm varchar2(64);
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') into machine_ip FROM dual;
select distinct TERMINAL into machine_nm from v$session where USERNAME='ITS'; -- MACHINE
INSERT INTO logon_off_hist(user_id,machine_ip,machine_nm, module_nm,st)
VALUES (:user_id,machine_ip,machine_nm,'ITS','O');
COMMIT_FORM;
clear_message;
END;
Subscribe to:
Post Comments (Atom)
How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10
#########################Install Oracle APEX 24.1################################ ----------------------------------------------------...
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment