PL/SQL tutorial 19: How To Create Database Event 'LogOn' Trigger In Oracle By Manish Sharma

------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.

-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at
for E-mail address please check About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[deepikajadhav]

Hi Manish...

Really great work.. I am new to Oracle PL/sql and your videos are really helping me...Thanks and keep uploading..:)

[keridince]

Thank you very much fir those videos, it's awesome

[arunrocketz]

You are gem of a person..Thank u so much..

[gregorykumeh]

Thank Sir, i just start watching ur video on PLSQL, it's very simple for me to understand especially being a beginner. I really need this course to get a work i'm from ms sql background.

[rajaskp]

thank u sir ...u r great ... keep this job..

[NigelCoutinhodec]

Hi Manish,

Thank you for your tutorials.

I have a question. For this trigger you used commit; while for others you did not. Any specific reason?

Thank you once again.

[pramodsikakolli]

may i know, why we dont have for each row and enable commands for this type of trigger..thanks in advance

[ashishrana]

Hi Manish, You only used Commit command on this trigger not before, Is it the specific functionality of SQL Developer?

[rohini.mgangadhar]

can i create befor logon trigger and also as after logoff trigger?

[sowmyar]

vedios are made very simple and easily understandable for beginners you manish sir.. please upload some more vedios regarding pl/sql interview questions for freshers

[rohini.mgangadhar]

can i craete a DDL trigger on usmsys schema being logged into HR schema?

[omkarlad]

is that commit important for system trigger ???

[deepum]

How to maintain scn to table using with triggers?

[animeshmanna]

Sir I when conn hr/hr then show the message my account is locked... please help me

[ntskm]

SIR WHY ARE WE USING COMMIT COMMAND IN THIS TRIGGER EVENT??

[MrDeepakkamath]

Why are we not using enable clause in these triggers which you had used in the earlier triggers?

[Sanal]

This trigger and the logoff both didn't work for me, showing some compiler errors. the code is here. Table created successfully but the trigger compiling with 2 errors
1. Error(1, 1): PL/SQL: SQL Statement ignored
2.Error(2, 22): PL/SQL: ORA-00936: missing expression

CREATE OR REPLACE TRIGGER TRACK_LOGON
AFTER LOGON ON SCHEMA
BEGIN
INSERT INTO HR_EVNT_AUDIT VALUES (
ORA_SYSEVENT, SYSDATE, CHAR(SYSDATE, 'HH24:MI:SS'), NULL, NULL);
COMMIT;
END;
/
CREATE TABLE "HR"."HR_EVNT_AUDIT"
   ( "EVENT_TYPE" VARCHAR2(20),
 "LOGON_DATE" DATE,
 "LOGON_TIME" VARCHAR2(20),
 "LOGOFF_DATE" DATE,
 "LOGOFF_TIME" VARCHAR2(20)
   )

Please help me to resolve it as soon as possible.
Thank you,

[dgtvztf]

hai
i started watching videos of plsql ...
when comes to triggers tutorial triggers are not created in oracle sql developer
can u pls tell me how to create triggers in oracle sql developer pls sort it out ASAP...

[MrDeepakkamath]

And also why are we using 'commit' here? You didn't use it in the earlier triggers.

[arunavabasak]

code is compiling successfully but table is not populating;please help sir