>>김정식 님께서 쓰시길<<
:: 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));
이게 맞는거겠지요.
|