oracle
文章平均质量分 52
nobody_2008
这个作者很懒,什么都没留下…
展开
-
Merge Into 不能执行Insert的原因
语法: MERGE INTO [your table-name] [rename your table here] USING ( [write your query here] )[rename your query-sql and using just like a table] ON ([conditional expression here] AND [...]....2010-05-26 16:37:27 · 2819 阅读 · 1 评论 -
sql实现查看oracle的表结构及备注(comments)
查看表结构: 看字段名与数据类型 select * from cols WHERE TABLE_name=upper( 'table_name ') 查看主键: select * from user_constraints where constraint_type= 'P ' and ...原创 2010-06-17 10:31:28 · 1161 阅读 · 0 评论