Oracle Solution for Error ora-01943

Solution for Oracle Error ORA-01943

ORA-01943: IDENTIFIED BY already specified

What triggered the Error:

The identified clause has been given twice.

What should we do to fix it:

Use only one identified by clause.