SQL> create table temp_mhe
  2  (
  3  lodgename varchar2
  4  .
SQL> ed
Wrote file afiedt.buf

  1  create table temp_mhe
  2  (
  3  lodgename VARCHAR2(15) CONSTRAINT lodging_PK PRIMARY KEY,
  4  address VARCHAR2(20),
  5  name VARCHAR2(25) constraint lodging1-UQ UNIQUE,
  6* )
SQL> /
name VARCHAR2(25) constraint lodging1-UQ UNIQUE,
                  *
ERROR at line 5:
ORA-02253: constraint specification not allowed here

SQL> ed
Wrote file afiedt.buf

  1  create table temp_mhe
  2  (
  3  lodgename VARCHAR2(15) CONSTRAINT lodging_PK PRIMARY KEY,
  4  address VARCHAR2(20),
  5  name VARCHAR2(25) constraint <B>lodging1_UQ</B> UNIQUE
  6* )
SQL> /

Table created.

SQL> select constraint_type, table_name, status
  2    from user_constraints where constraint_name = 'LODGING1_UQ';

C TABLE_NAME                     STATUS
- ------------------------------ --------
U TEMP_MHE                       ENABLED

SQL>