We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 12_1_4 || TAB_DEBTOR_LIST 乫 Å×ÀÌºí¿¡ µ¥ÀÌÅÍ ÀÔ·ÂINSERT INTO TAB_DEBTOR_LIST(DEBTOR_LIST_NO ,DEBTOR_LIST_TEL ,DEBTOR_LIST_PHONE ,DEBTOR_LIST_POSTAL ,DEBTOR_LIST_ADDRESS_1 ,DEBTOR_LIST_ADDRESS_2 ,DEBTOR_LIST_REGIST_DATE ,DEBTOR_LIST_INPUT ,DEBTOR_LIST_MGR_NUM)VALUES ('2013040901' ,'01011111111' ,'01011111111' ,'135-011' ,'¼¿ï °³²±¸ ³íÇö1µ¿' ,'11' ,SYSDATE ,'2013032901' ,'2013032901');
¡á¿¹ 12_1_5 || TAB_BAK_LISTSELECT DEBTOR_LIST_NO, DEBTOR_BAK_SEQ, DEBTOR_BAK_TEL, DEBTOR_BAK_PHONE, DEBTOR_BAK_ZIPCODE, DEBTOR_BAK_ADDRESS_1, DEBTOR_BAK_ADDRESS_2, DEBTOR_BAK_REGIST_DATE, DEBTOR_BAK_INPUT, DEBTOR_BAK_MGR_NUM FROM TAB_DEBTOR_BAK;
¡á¿¹ 12_1_6 || TAB_DEBTOR_LIST µ¥ÀÌÅÍ ¼öÁ¤UPDATE TAB_DEBTOR_LISTSET DEBTOR_LIST_TEL='01099999999', DEBTOR_LIST_MGR_NUM = '2013032104¡¯WHERE DEBTOR_LIST_NO = '2013040901';
¡á¿¹ 12_1_7 || ¼öÁ¤ µ¥ÀÌÅÍ TAB_DEBTOR_HISTORY ÀÔ·Â È®ÀÎSELECT DEBTOR_LIST_NO, DEBTOR_BAK_SEQ, DEBTOR_BAK_TEL, DEBTOR_BAK_PHONE, DEBTOR_BAK_ZIPCODE, DEBTOR_BAK_ADDRESS_1, DEBTOR_BAK_ADDRESS_2, DEBTOR_BAK_REGIST_DATE, DEBTOR_BAK_INPUT, DEBTOR_BAK_MGR_NUMFROM TAB_DEBTOR_BAK;
¡á¿¹ 12_2_1 || init.ora È®ÀÎ/*# db_file_multiblock_read_count = 8#SMALL#db_file_multiblock_read_count = 16#MEDIUM#db_file_multiblock_read_count = 32#LARGE#Datawarehousedb_block_size=8192 # Transaction processing# db_block_size=4096 open_cursors=300#Transaction processing*/
¡á¿¹ 12_2_2 || Å×ÀÌºí »ý¼º ¿¹____CREATE TABLE____ LEEOK.A_MENU_PGM( MENU_ID VARCHAR2(20 BYTE) NOT NULL, PGM_ID VARCHAR2(20 BYTE) NOT NULL, DESCRIPTION VARCHAR2(200 BYTE))TABLESPACE SYSTEMPCTUSED 60PCTFREE 10INITRANS 1MAXTRANS 255STORAGE ( INITIAL 256K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT )LOGGINGNOCOMPRESSNOCACHENOPARALLELMONITORING;