>>김정식 님께서 쓰시길<<

:: ORACLE 8i PersnalOracle입니다.

::

:: win98이구요.

::

:: 자료의 형에 DATE와 OBJECT가 있읍니다.

::

:: SQL> DESC PHONE_SET;

:: 이름 널? 유형

:: ----------------------------------------- -------- ----------------------------

:: NUM_1 NUMBER(4)

:: NUM_2 NUMBER(8)

::

:: SQL> DESC C_CUST;

:: 이름 널? 유형

:: ----------------------------------------- -------- ----------------------------

:: ID NOT NULL VARCHAR2(14) primary key

:: NAME VARCHAR2(30)

:: TRADENAME VARCHAR2(40)

:: REGDATE DATE

:: EMAIL VARCHAR2(40)

:: PHONE_1 PHONE_SET

:: PHONE_2 PHONE_SET

:: PHONE_3 PHONE_SET

:: PHONE_4 PHONE_SET

:: POST_1 VARCHAR2(7)

:: ADDR_1 VARCHAR2(100)

:: POST_2 VARCHAR2(7)

:: ADDR_2 VARCHAR2(100)

:: BIGO VARCHAR2(1000)

::

:: SQL> INSERT INTO C_CUST

:: VALUES ('7402161212345','똘똘이','CAR mareket','01/03/29','lolo@han.com',

:: PHONE_1(0002,12457896),PHONE_2(0018,01236547),PHONE_3(0054,03241254),PHONE_4(0051,04423465),

:: '135462','서울시 강남구 도곡동 ',

:: '456321','부천시 강님 빌딩',

:: '하하히히'

:: );

::

:: PHONE_1(0051,05153836),PHONE_2(0011,08831351),PHONE_3(0051,04417070),PHONE_4(0051,04423465),

:: *

:: 3행에 오류:

:: ORA-00904: 열명이 부적합합니다

::

:: SQL> INSERT C_CUST INTO [ID, PHONE_1] VALUES('451278',PHONE_1(1234,65498712));

:: INSERT C_CUST INTO [ID, PHONE_1] VALUES('451278',PHONE_1(1234,65498712))

:: *

:: 1행에 오류:

:: ORA-00925: INTO 키워드가 없습니다

::

:: 이런 오류가 나옵니다.

::

:: 어떻게 해결이 안될까?

SQL> INSERT INTO C_CUST

VALUES ('7402161212345','똘똘이','CAR mareket','01/03/29','lolo@han.com',

PHONE_SET(0002,12457896),PHONE_SET(0018,01236547),

PHONE_SET(0054,03241254),PHONE_SET(0051,04423465),

'135462','서울시 강남구 도곡동 ',

'456321','부천시 강님 빌딩',

'하하히히'

);

SQL> INSERT INTO C_CUST(ID, PHONE_1)

VALUES('451278',PHONE_SET(1234,65498712));

이게 맞는거겠지요.