Updating rows with %rowtype
Can we update rows with the help of %rowtype?
Example:
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments