½Äº°ÀÚ´Â ¸ÞŸ µ¥ÀÌÅÍ °´Ã¼¸¦ °íÀ¯ÇÏ°Ô ½Äº°ÇÏ´Â À̸§ÀÔ´Ï´Ù. À̸§ ÁöÁ¤ ±ÔÄ¢Àº Ç¥ÁØ Oracle À̸§ ÁöÁ¤ ±ÔÄ¢À» µû¸¨´Ï´Ù. ¸ðµç ½Äº°ÀÚ´Â ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÏÁö ¾Ê½À´Ï´Ù.
owner.{ cube | dimension | table }.{ measure | column }
| Ç¥±â¹ý | ÀοëµÈ ID | ÀοëµÇÁö ¾ÊÀº ID |
|---|---|---|
| óÀ½ ¹®ÀÚ |
ÀÓÀÇÀÇ ¹®ÀÚÀÔ´Ï´Ù. | µ¥ÀÌÅͺ£À̽º ¹®ÀÚ ÁýÇÕÀÇ ¾ËÆÄºª ¹®ÀÚÀÔ´Ï´Ù. |
| ±âŸ ¹®ÀÚ |
¸ðµç ¹®ÀÚ, ±¸µÎÁ¡ ¹× °ø¹éÀÌ Çã¿ëµË´Ï´Ù.
Å« µû¿ÈÇ¥ ¹× ³Î(\0)Àº Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |
µ¥ÀÌÅͺ£À̽º ¹®ÀÚ ÁýÇÕÀÇ ¹®¼ýÀÚ ¹× ¹ØÁÙ(_)ÀÌ Çã¿ëµË´Ï´Ù.
´Þ·¯ ±âÈ£($) ¹× ÆÄ¿îµå ±âÈ£(#)´Â Çã¿ëµÇÁö¸¸ ±ÇÀåµÇÁö ¾Ê½À´Ï´Ù.
Å« µû¿ÈÇ¥ ¹× ³Î(\0)Àº Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |
| ¿¹¾à¾î | Çã¿ëµÇÁö¸¸ ±ÇÀåµÇÁö ¾Ê½À´Ï´Ù. | Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |
SH.SALES_CUBE.QUANTITY_SOLD´Â SH ½ºÅ°¸¶ÀÇ Sales Å¥ºê¿¡¼ À̸§ÀÌ Quantity SoldÀÎ ÃøÁ¤ ´ÜÀ§¸¦ ½Äº°ÇÕ´Ï´Ù.
Copyright © 2003, 2007, Oracle. All rights reserved.