oracle case when 使用

			select 
			 owner,
			 table_name,
			 column_name filed_name,
			 nullable, 
			 CASE WHEN nullable='Y' THEN  '是' 
						ELSE '否' END  is_null,
			 data_type, 
			CASE WHEN  data_type='DATE' THEN  a.data_type 
				 WHEN data_type='TIMESTAMP(6)' THEN  a.data_type
				 WHEN data_type='NUMBER' and DATA_precision is  null THEN data_type	
				 WHEN data_type='NUMBER'THEN data_type || '(' || DATA_precision || ',' || data_scale ||')'
			     ELSE a.data_type || '(' || a.data_length || ')' END  column_type
			from all_tab_columns a
			WHERE  owner = 'yourDbName'   --库名