We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
-- Å×ÀÌºí »ý¼º____CREATE TABLE____ LEEOK.DATA_TYPE ( DT_SEQ VARCHAR2(2) NOT NULL, DT_CHAR CHAR(100) NULL, DT_VARCHAR2 VARCHAR2(100) NULL, DT_NUMBER_1 NUMBER NULL, DT_NUMBER_2 NUMBER(9, 2) NULL, DT_DATE DATE NULL, DT_TIMESTAMP TIMESTAMP(6) NULL, DT_LONG LONG NULL, DT_BLOB BLOB NULL, DT_CLOB CLOB NULL);ALTER TABLE DATA_TYPE ADD ( CONSTRAINT DATA_TYPE_PK PRIMARY KEY(DT_SEQ));
¡á¿¹ 5_1_1 || CHARÀÇ ±æÀ̸¦ üũSELECT DT_CHAR, RTRIM(DT_CHAR) FROM DATA_TYPEUNION ALLSELECT TO_CHAR(LENGTHB(DT_CHAR)), TO_CHAR(LENGTHB(RTRIM(DT_CHAR)))FROM DATA_TYPE;
¡á¿¹ 5_1_2 || VARCHAR2ÀÇ ±æÀ̸¦ üũSELECT DT_VARCHAR2, TRIM(DT_VARCHAR2) FROM DATA_TYPEUNION ALLSELECT TO_CHAR(LENGTHB(DT_VARCHAR2)), TO_CHAR(LENGTHB(TRIM(DT_VARCHAR2))) FROM DATA_TYPE;
¡á¿¹ 5_1_3 || °°Àº ŸÀÔ(CHAR)ÀÇ Á¶ÀÎSELECT T1.DT_SEQ, T1.DT_CHAR, T1.DT_VARCHAR2, T1.DT_NUMBER_1,T1.DT_NUMBER_2, T1.DT_DATEFROM DATA_TYPE T1, DATA_TYPE T2WHERE T1.DT_SEQ = T2.DT_SEQAND T1.DT_CHAR = T2.DT_CHAR;
¡á¿¹ 5_1_4 || ´Ù¸¥ ŸÀÔ(CHAR, VARCHAR)ÀÇ Á¶ÀÎSELECT T1.DT_SEQ, T1.DT_CHAR, T1.DT_VARCHAR2, T1.DT_NUMBER_1,T1.DT_NUMBER_2, T1.DT_DATEFROM DATA_TYPE T1, DATA_TYPE T2WHERE T1.DT_SEQ = T2.DT_SEQAND T1.DT_CHAR = T2.DT_VARCHAR2;
¡á¿¹ 5_1_5 || ´Ù¸¥ ŸÀÔ(CHAR, VARCHAR)ÀÇ Á¶ÀÎSELECT T1.DT_SEQ, T1.DT_CHAR, T1.DT_VARCHAR2, T1.DT_NUMBER_1,T1.DT_NUMBER_2, T1.DT_DATEFROM DATA_TYPE T1, DATA_TYPE T2WHERE T1.DT_SEQ = T2.DT_SEQAND TRIM(T1.DT_CHAR) = T2.DT_VARCHAR2;
¡á¿¹ 5_1_6 || NUMBERÀÇ ±æÀÌ Ã¼Å©UPDATE DATA_TYPE SET DT_NUMBER_1=123456789012345678901234567890.12345678901234567890123456789, DT_NUMBER_2=1234567.99WHERE DT_SEQ = '01';
UPDATE DATA_TYPE SET DT_NUMBER_1=-123456789012345678901234567890.12345678901234567890123456789,DT_NUMBER_2=-1234567.99WHERE DT_SEQ = '02';
SELECT DT_SEQ, DT_CHAR, DT_VARCHAR2, DT_NUMBER_1,VSIZE(DT_NUMBER_1)||' BYTE' AS Å©±â, DT_NUMBER_2FROM DATA_TYPE;
¡á¿¹ 5_1_7 || DATE ŸÀÔ Á¶È¸SELECT VSIZE(DT_DATE)||' BYTE' AS Å©±â, TO_CHAR(DT_DATE,'YYYY/MM/DD') AS ³â¿ùÀÏ, TO_CHAR(DT_DATE,'YYYY/MM/DD HH24:MI:SS') AS ³â¿ùÀϽúÐÃÊ , DT_DATE, SYSDATE-7FROM DATA_TYPE;
¡á¿¹ 5_1_8 || LAST_DAY ÇÔ¼ö »ç¿ëSELECT LAST_DAY(SYSDATE) FROM DUAL;
¡á¿¹ 5_1_9 || TO_CHAR ÇÔ¼ö »ç¿ëSELECT TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') FROM DUAL;
¡á¿¹ 5_1_10 || TO_DATE ÇÔ¼ö »ç¿ëSELECT TO_DATE('20100503 09:59:25','yyyymmdd hh24:mi:ss') FROM DUAL;
¡á¿¹ 5_1_11 || ADD_MONTHS ÇÔ¼ö »ç¿ëSELECT ADD_MONTHS(SYSDATE,1) FROM DUAL;
¡á¿¹ 5_1_13 || MONTHS_BETWEEN ÇÔ¼ö »ç¿ëSELECT MONTHS_BETWEEN(SYSDATE,SYSDATE-30) FROM DUAL;
¡á¿¹ 5_1_14 || NEXT_DAY ÇÔ¼ö »ç¿ëSELECT NEXT_DAY(SYSDATE, 7) FROM DUAL;
¡á¿¹ 5_1_15 || TIMESTAMP ŸÀÔ Á¶È¸SELECT T1.DT_SEQ, TO_CHAR(T1.DT_TIMESTAMP,'YYYYMMDD HH24:MI:SS:FF') AS EX1, TO_CHAR(T1.DT_TIMESTAMP, 'YYYYMMDDHH24MISSFF3') AS EX2, VSIZE(T1.DT_TIMESTAMP)||' BYTE' AS BYTE, T1.DT_DATEFROM DATA_TYPE T1;