ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[¤À¨É] ¬d¬ÝTable¬O§_¦s¦b Column¬O§_¦s¦b Column¸Ô²Ó¸ê®Æ

[¤À¨É] ¬d¬ÝTable¬O§_¦s¦b Column¬O§_¦s¦b Column¸Ô²Ó¸ê®Æ

/*¬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'

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD