ORA-00957: duplicate column name

in-oracle

SQL> create table test_ins (x number(1));

Table created.

SQL> insert into test_ins (x, x) values (1, 2);
insert into test_ins (x, x) values (1, 2)
                      *
ERROR at line 1:
ORA-00957: duplicate column name


SQL> insert into test_ins (test_ins.x, x) values (1, 2);

1 row created.

SQL> select * from test_ins;

         X
----------
         2

SQL>

in-postgres

lark=# create table test_ins (x integer);
CREATE TABLE
lark=# insert into test_ins (x, x) values (1, 2);
ERROR:  column "x" specified more than once
LINE 1: insert into test_ins (x, x) values (1, 2);
                                 ^
lark=# insert into test_ins (test_ins.x, x) values (1, 2);
ERROR:  column "test_ins" of relation "test_ins" does not exist
LINE 1: insert into test_ins (test_ins.x, x) values (1, 2);
                              ^
lark=#