Oracle使用总结

1、新增数据提示违反约束：

附上sqlserver 查询数据表的主键约束：

--查询用户自建的表约束
SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT'
and OBJECT_NAME(OBJECT_ID) like 'PK_SYS_BUTTON%'

“fool me once，shame on you. fool me twice, shame on me.”，翻译过来的意思是“愚弄我一次，是你坏；愚弄我两次，是我蠢”。