Oracle knowledge collection

Restoration After Oracle Deletion

Savepoint;

Delete from student;

Rollback to;

Modify date format in Oracle

Alter session set nls_date_format = 'yyyy-mm-dd'

Query records with blank or non-empty fields in Oracle

Select * from student where birthday is null

Select * from student where birthday is not null

Delete a configuration file

Drop profile a [cascade]

Alter user xh account unlock: unlock the user

Limit the number of user logon failures

1. Create a configuration file. If the user fails to log on three times, the lock will be performed for two days. The keyword in the blacklist is:

Create profile a limit failed_login_attempts 3 password_lock_time 2

2. Apply this configuration file to the user xh

Alter user xh profile