Example 1: Locking a Table in READ MODE

    SQL> LOCK TABLE EMPLOYEES IN PROTECTED READ MODE NOWAIT;

    Example 2: Locking Two Tables in Different Modes

    SQL> LOCK TABLE DB1.JOB_HISTORY IN SHARED WRITE MODE,
    cont>      DB2.SALARY_HISTORY IN EXCLUSIVE WRITE MODE;