Guest User

Untitled

a guest
Apr 20th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 1.27 KB | None | 0 0
  1. ret_array array_book_t;
  2.     BEGIN
  3.       SELECT ean, ASIN, title, category_amazon, price, review, endpoint,
  4.         publisher, format, pages, dated, edition
  5.       INTO ret_array
  6.       FROM (
  7.         SELECT
  8.         ean, ASIN, title, category_amazon, price, review, endpoint,
  9.         publisher, format, pages, dated, edition, ROWNUM r
  10.         FROM (
  11.           SELECT DISTINCT book.*, id, val, book_id, authors_id
  12.           FROM Book, BookAuthors, Authors
  13.           WHERE (
  14.             ( title_begin   IS NULL OR title LIKE 'title_begin%' ) AND
  15.             ( title_end     IS NULL OR title LIKE '%title_end' ) AND
  16.             ( title_inc     IS NULL OR title LIKE '%title_inc%' ) AND
  17.             ( price_min     IS NULL OR price >= price_min ) AND
  18.             ( price_max     IS NULL OR price <= price_max ) AND
  19.             ( Book.ean = BookAuthors.book_id ) AND
  20.             ( Authors.id = BookAuthors.authors_id ) AND
  21.             ( authors_begin IS NULL OR BookAuthors.authors_id LIKE 'authors_begin%' ) AND
  22.             ( authors_end   IS NULL OR BookAuthors.authors_id LIKE '%authors_end' ) AND
  23.             ( authors_inc   IS NULL OR BookAuthors.authors_id LIKE '%authors_inc%' )
  24.           )
  25.         )
  26.       ) WHERE r BETWEEN the_begin AND the_end;
  27.     END search_books;
Add Comment
Please, Sign In to add comment