orclz> declare
  2  type books_table is TABLE OF books%ROWTYPE;
  3  type empcurtype is REF CURSOR ;
  4  nt_books_table books_table:=books_table();
  5  begin
  6  open empcurtype for select * from books ;
  7  fetch empcurtype BULK COLLECT INTO nt_books_table;
  8  close empcurtype ;
  9  FOR i in nt_books_table.FIRST..nt_books_table.LAST loop
 10  dbms_output.put_line(nt_books_table(i));
 11  end loop;
 12  end;
 13  /
type books_table is TABLE OF books%ROWTYPE;
                             *
ERROR at line 2:
ORA-06550: line 2, column 30:
PLS-00201: identifier 'BOOKS' must be declared

SQL> CREATE TABLE books (
  2  isbn CHAR(10) PRIMARY KEY,
  3  category VARCHAR2(20),
  4  title VARCHAR2(100),
  5  num_pages NUMBER,
  6  price NUMBER,
  7  copyright NUMBER(4),
  8  author1 NUMBER CONSTRAINT books_author1
  9  REFERENCES authors(id),
 10  author2 NUMBER CONSTRAINT books_author2
 11  REFERENCES authors(id),
 12  author3 NUMBER CONSTRAINT books_author3
 13  REFERENCES authors(id)
 14  );
REFERENCES authors(id),
           *
ERROR at line 9:
ORA-00942: table or view does not exist

open empcurtype for select * from books ;

declare
type books_table is TABLE OF books%ROWTYPE;
type empcurtype is REF CURSOR ;
empcur empcurtype;
nt_books_table books_table:=books_table();
begin
open empcur for select * from books ;
fetch empcur BULK COLLECT INTO nt_books_table;
close empcur ;
FOR i in nt_books_table.FIRST..nt_books_table.LAST loop
dbms_output.put_line(nt_books_table(i));
end loop;
end;
/

dbms_output.put_line(nt_books_table(i).isbn);
dbms_output.put_line(nt_books_table(i).category);
.
.
.