Å×À̺í À̸§, Ä÷³¸í, Á¤º¸ Á¶È¸ Äõ¸®
1. Å×ÀÌºí ¸í º¸±â
select *
from ALL_TAB_COMMENTS
where TABLE_NAME = ' Å×À̺í À̸§ ' ;
°á°ú :
OWNER | TABLE_NAME | TABLE_TYPE | COMMENTS |
Å×ÀÌºí ¸í | Å×À̺í Á¾·ù (TABLE / VIEW) | Å×À̺í ÁÖ¼® |
2. Ä÷³ ¸í º¸±â
select *
from ALL_COL_COMMENTS
where TABLE_NAME = ' Å×À̺í À̸§ ' ;
OWNER | TABLE_NAME | COLUMN_NAME | COMMENTS |
Å×ÀÌºí ¸í | Ä÷³¸í | Ä÷³ ÁÖ¼® |
3. Å×À̺í Á¤º¸ º¸±â
select *
from ALL_TAB_COLUMNS
where TABLE_NAME = ' Å×À̺í À̸§ ' ;
OWNER | TABLE_NAME | COLUMN_NAME | DATA_TYPE | DATA_TYPE_MOD | DATA_TYPE_OWNER |
Å×À̺íÀ̸§ | Ä÷³À̸§ | µ¥ÀÌÅÍŸÀÔ | Ä÷³¼öÁ¤ÀÚ | Ä÷³Àǵ¥ÀÌÅÍŸÀÔ¿À³Ê |
DATA_LENGTH | DATA_PRECISION | DATA_SCALE | NULLABLE | COLUMN_ID | DEFAULT_LENGTH |
µ¥ÀÌÅÍ ±æÀÌ | null °¡´É | Ä÷³_ID | ¿ÀDZ⺻°ªÀDZæÀÌ |
DATA_PRECISION : ±æÀÌ : 10 Áø¼ö ¼ýÀÚ (NUMBER) ¶Ç´Â ÀÌÁø¼ýÀÚ (float)
DATA_SCALE : number À϶§ ¼ýÀÚ
COLUMN_ID : ROW_ID¿Í °°Àº ÀǹÌ, 1,2,3.. °°Àº ¼ýÀÚ·Î µÇ¾îÀÖÀ½
DATA_DEFAULT | NUM_DISTINCT | LOW_VALUE | HIGH_VALUE | DENSITY | NUM_NULLS |
Ä÷³ÀÇ µðÆúÆ® °ª | Ä÷³ÀÇdistinct°ªÀÇ°³¼ö | Ä÷³Àdz·Àº°ª | Ä÷³ÀdzôÀº°ª | Ä÷³ÀÇ ¹Ðµµ | nullÀ» °¡Áø Ä÷³ÀÇ°³¼ö |
NUM_BUCKETS | LAST_ANALYZED | SAMPLE_SIZE | CHARCTER_SET_NAME | CHAR_COL_DECL_LENGTH | GLOBAL_STATS |
¿¿¡´ëÇÑ È÷½ºÅä±×·¥¿¡¼ ¹öŶÀÇ °³¼ö | Ä®·³À» ºÐ¼®Çß´ø °¡Àå ÃÖ±ÙÀÇ ³¯Â¥ | Ä®·³ ºÐ¼®¿¡ »ç¿ëµÇ´Â Ç¥º»ÀÇ Å©±â | Character set name | Declaration length of character type column | ±âº» ÆÄƼ¼ÊÀ» º´ÇÕÇÏÁö ¾Ê°í °è»êÇÑ Åë°è°¡ ÀÖ½À´Ï±î? |
USER_STATS | AVG_COL_LEN | CHAR_LENGTH | CHAR_USED | V80_FMT_IMAGE | DATA_UPGRADED |
Åë°è´Â »ç¿ë°¡°¡ Á÷Á¢ÀÔ·ÂÇÑ°ÍÀΰ¡? | Ä÷³ÀÇ Æò±Õ ±æÀÌ(byte) | ¹®ÀÚ Ä÷³ÀÇ ÃÖ°í ±æÀÌ | C or B | 8.0À̹ÌÁö Çü½ÄÀÇ ¿µ¥ÀÌÅÍ Àΰ¡? | ¿µ¥ÀÌÅÍ´Â ÃֽŠÀ¯Çü ¹öÀüÇü½ÄÀ¸·Î ¾÷±×·¹ÀÌµå µÇ¾îÀÖ³ª? |
CHAR_USED : C - ÃÖ´ë ±æÀÌ°¡ ¹®ÀÚ¿¡ ÁöÁ¤µÇ¾îÀÖ´Â °æ¿ì, B - ¹ÙÀÌÆ®À϶§
Ãâó: https://domoyosi.tistory.com/6 [²¿²¿³²ÆíÀÇ ÁÖ¿ö¸Ô±â]