https://www.udemy.com/course/plsql-by-example/learn/lecture/3169194#overview
record는 복합 데이터 타입이다.
CREATE OR REPLACE PROCEDURE process_customer
(c_id IN customer.customer_id%type)
IS
c_record customer%rowtype;
BEGIN
SELECT *
INTO c_record
FROM customer
WHERE customer_id = c_id;
END;
-- 다른 procedure에서 호출해서 사용할 수 있다.
CREATE PROCEDURE show_customer
(
customer_in customer%ROWTYPE
)
IS
BEGIN
머시기;
END;
-- 다른 procedure에서 호출해서 사용할 수 있다.
CREATE OR REPLACE PROCEDURE show_customer
(
customer_in customer%ROWTYPE
)
IS
BEGIN
INSERT INTO CUSTOMER VALUES CUSTOMER_IN;
COMMIT;
END;
-- 다른 procedure에서 호출해서 사용할 수 있다.
CREATE OR REPLACE PROCEDURE show_customer
(
customer_in customer%ROWTYPE
)
IS
BEGIN
UPDATE customer set row = customer_in
WHERE customer_id = customer_in.customer_id ;
COMMIT;
END;
TYPE customer_info IS RECORD
(
name VARCHAR2(100),
total_sales NUMBER,
deliver_pref VARCHAR2(10)
);