Oracle
yibi229
专注于Web开发、移动开发;主打开发语言:. net/c# java ionic h5/hybrid app jquery/typescript
展开
-
查询关于数据库信息
Oracle: 查询表基本信息: select utc.column_name,utc.data_type,ucc.comments,utc.data_length,utc.data_precision, utc.data_Scale,utc.nullable,utc.data_default from user_tab_columns utc,user_col_c原创 2013-11-29 10:36:49 · 528 阅读 · 0 评论 -
关于Oracle
列转行函数:WM_CONCAT select SC.ID, SC.BUSINESS_TYPE, SC.SEND_TYPE, AV.VAL BTYPENAME,WM_CONCAT(SCD.USER_ID) USERAPPEND from x1 sc left join x2 scd on sc.id = scd.SEND_ID left join x3 av on av.NAME = sc原创 2013-12-27 12:51:39 · 452 阅读 · 0 评论