Declare ---- Define a varibable with a record type employee employee%rowtype; begin ---- initialize field values employee.empno := 1; employee.first_name := 'Greg'; employee.last_name := 'Williams'; employee.country := 'USA'; --insert into the table insert into employee values ( employee.empno, employee.first_name, employee.last_name, employee.country ); commit; end; /
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.