/*¬d¬ÝTable¬O§_¦s¦b Column¬O§_¦s¦b Column¸Ô²Ó¸ê®Æ*/
SELECT TABLE_NAME ¸ê®Æªí¦WºÙ
, COLUMN_NAME Äæ¦ì¦WºÙ
, DATA_TYPE Äæ¦ì«¬ºA
, DATA_LENGTH Äæ¦ìªø«×
, DATA_PRECISION ºë½T«×_Number«¬ºA¾ã¼Æ¦ì¼Æ
, DATA_SCALE ºë½T«×_Number«¬ºA¤p¼ÆÂI¦ì¼Æ
, NULLABLE ¬O§_¤¹³\¬°ªÅ
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME='PPM12' |