![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
happy是一头小猪
坚持、专注、努力
展开
-
联表查询两列一对多,整理成一行,多的那一列逗号隔开
--SQL SERVER--试图1create view v_projectuser asselect t.F_ProjectId,t.F_UserId,u.F_ChineseName from T_ProjectUser t,T_User u where t.F_UserId = u.f_id and t.F_Enabled = '1';--试图2(依赖试图1)create view v_projectusername asSELECT a.F_ProjectId , ST...原创 2021-05-10 14:10:40 · 277 阅读 · 0 评论 -
oracle,查看字段上的约束。
select * from all_constraints where table_name = 'TABLENAME';select * from User_Cons_Columns where table_name = 'TABLENAME';alter table TABLENAMEdrop constraint SYS_C006694;--删除约束原创 2019-11-20 16:14:08 · 1143 阅读 · 0 评论