Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

Archive for January, 2023

Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries

Posted by Mir Sayeed Hassan on 29th January 2023

Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries Find the First Day of the Month SQL> SELECT TRUNC (SYSDATE, ‘MONTH’) FROM DUAL; TRUNC(SYS ——— 01-JAN-23 Find the Last Day of the Month SQL> SELECT TRUNC (LAST_DAY (SYSDATE)) FROM DUAL; TRUNC(LAS ——— 31-JAN-23 Find… Read more..

Posted in DBA Administration | Comments Off on Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries

How to create the trigger for failed & success login attemp in Oracle Database

Posted by Mir Sayeed Hassan on 18th January 2023

How to create the trigger for failed & success login attempt in Oracle Database Note: The below given trigger is created to attempt the success and failed login attempt of the all the user in Oracle database., Data will be recorded in the table as well as at the OS Level (directory loc). Verify the Read More

Posted in DBA Administration | Comments Off on How to create the trigger for failed & success login attemp in Oracle Database