I tried to insert a record into oracle by using row, and failed, I will really appreciate it if someone could tell me if there is some grammar in sql like this: Thanks in advance:
--insert value
DECLARE
v_pay_table_row pay_table%TYPE;
BEGIN
v_pay_table.pname:=&pname;
v_pay_table.pay_type:=&pay_type;
v_pay_table.pay_rate:=&pay_rate;
v_pay_table.eff_date:=&eff_date;
v_pay_table.prev_pay:=&prev_pay;
--insert
INSERT INTO pay_table VALUES ROW=v_pay_table_row;
END;