1. ์ธ์ฌ๋ง์คํฐ์ 1:1 mapping๋๋ ์ฌ๋ด๋์ถ์์ฅ ๊ธฐ์ด๋ฐ์ดํฐ๋ฅผ ์ฝ์ ํ๋ ํ๋ก์์ ๋ฅผ ์์ฑํด๋ณด์ USE OSS; #์ง์ ์ ์ํ์ก ์ถ๊ฐ ALTER TABLE TB_LOAN ADD COLUMN MONTH_PAY NUMERIC(10) NOT NULL; #์ปฌ๋ผ ์์น ์ด๋ ALTER TABLE TB_LOAN MODIFY MONTH_PAY NUMERIC(10) AFTER LOAN_AMOUNT; ALTER TABLE TB_LOAN MODIFY BALANCE NUMERIC(10) AFTER TOTAL_PAY; SELECT * FROM TB_LOAN; DELIMITER $$ CREATE OR REPLACE PROCEDURE INSERT_LOAN(OUT v_result INT) /* @DESCRIPTION LOAN ๋ฐ..
