Example 12-15: Object view for the Book datagram

CREATE VIEW books AS
SELECT Book_T( b.ISBN, 
             b.Title, 
             b.Price, 
             Person_T( a.First_Name, a.Last_Name )
           ) as Book
  FROM book_table b, 
       author_table a 
 WHERE b.author_id = a.id;