SQL> select TABLE_NAME, column_name from user_cons_columns where table_name='ACCOUNTS_USERS';TABLE_NAME COLUMN_NAME
------------------------------ --------------------
ACCOUNTS_USERS ID
ACCOUNTS_USERS PASSWORD
ACCOUNTS_USERS NAME
ACCOUNTS_USERS ID
SQL> desc ACCOUNTS_USERS;
Name Type Nullable Default Comments
-------- ------------ -------- ------- --------
ID VARCHAR2(20)
NAME VARCHAR2(20)
PASSWORD VARCHAR2(32)
EMAIL VARCHAR2(30) Y 有一个可以为空的列名列错了
------------------------------ --------------------
ACCOUNTS_USERS ID
ACCOUNTS_USERS PASSWORD
ACCOUNTS_USERS NAME
ACCOUNTS_USERS ID
SQL> desc ACCOUNTS_USERS;
Name Type Nullable Default Comments
-------- ------------ -------- ------- --------
ID VARCHAR2(20)
NAME VARCHAR2(20)
PASSWORD VARCHAR2(32)
EMAIL VARCHAR2(30) Y 有一个可以为空的列名列错了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货