用记录的形式向表中插入一行数据

时间:2022-09-23 08:30:23

可以向表中插入一行数据,用记录的形式,例如:


declare
     my_book books%rowtype;
begin my_book.isbn :='1-334-123234';
my_book.title :='ORACLE PL/SQL';
my_book.summary :='General user guide and  reference';
my_book.author :='FEUERSTEIN,STEVEN AND BULL PRIBYL';
my_book.page_count :=1000;

update books set row =my_book where isbn=my_book.isbn;
--注意此处
end;