ªð¦^¦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 : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD