Counting failed attempt

0 votes

1 answer

194 views

oracle oracle-11g view oracle-sql-developer

                          Here is my code:

    create table failed_login_attempts(
    login_id number(5) primary key,
    date_created timestamp default systimestamp,
    email varchar2(110),
    ip varchar2(24),
    mac varchar2(18),
    attempt number(1),
    isLocked number(1)
    );

I want to count attempt column and if 5 then isLocked become 1 from 0;
How can I make query, view or procedure?
                        

Asked by MikeJ (13 rep)

May 7, 2021, 01:11 AM
Last activity: Jun 29, 2025, 04:03 PM

Counting failed attempt

Related Questions