Author(AID: number, name: varchar2) Book(ISBN: varchar2, Title: varchar2, Year:

Question

Author(AID: number, name: varchar2)

Book(ISBN: varchar2, Title: varchar2, Year: number, Price: number, PublisherID: number)

Wrote(AuthorID: number, BookISBN: varchar2)

Publisher(PID: number, Name: varchar2, Address: varchar2)

For instance, we could have

<1, "Tony"> in Author’

<2, "Amy"> in Author

<"111", "Book", 2016, 40, 51> in Book

<1, "111"> in Wrote

<2, "111"> in Wrote

<51, "AB", "New York"> in Publisher

Write a cursor that will return results for a user query: “List all books published by a given publisher.”

Explanation / Answer

CREATE OR REPLACE FUNCTION get_allitems(id) RETURN SYS_REFCURSOR AS my_cursor SYS_REFCURSOR; BEGIN OPEN my_cursor FOR SELECT Title FROM Book WHERE PublisherID = id; RETURN my_cursor; END get_allitems;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.