this is tech article blog

hoterran posted @ 2008年2月02日 21:36 in bbb with tags oracle plsql , 1083 阅读

it is ok ?

select table_name||'.'||column_name||'  '||decode(data_type,'CHAR',data_type||'('||data_length||')','NCHAR',data_type||'('||data_length||')','VARCHAR2',data_type||'('||data_length||')','NVARCHAR2',data_type||'('||data_length||')', 'NUMBER',DECODE(data_precision,NULL,'NUMBER',data_type||'('||data_precision||','||data_scale||')'),data_type) FROM user_tab_columns WHERE table_name NOT LIKE 'BIN%' ORDER BY 1;


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter