title: PLSQL printing Author with Publisher
body: <p>I am trying to write a PLSQL block to display details of books along with their Author and Publisher.
  problem statement is as follow:
  Use String functions to display only the first 10 letters of column 'Title'  and Sort the result set based on 'Title' in ascending order.
  Schema details are given below:-</p>
  <p>Table Name       Columns</p>
  <p>1.author         authorid, firstname, lastname</p>
  <p>2.book       author_id, bookid, publisherid, title</p>
  <p>3.publisher  publisherid, publishername</p>
  <p>Output format is as follows:</p>
  <p>BOOKID.............TITLE.............publisher.............Author</p>
  <p>639163050...........10 Years o...........Prentice Hall...........Paul Deitel</p>
  <p>330895717...........African Fo...........Prentice Hall...........Tem Nieto</p>
  <p>my output is coming the same as required but somehow hackerrank is not accepting it. Please refer the code below and help if you can:</p>
  <pre><code>set serveroutput on;
  declare
  cursor c is
  
  select * from book b 
  left join author on authorid=author_id 
  left join publisher p on b.publisherid=p.publisherid
  order by title asc;
  
  begin
  
   dbms_output.put_line('BOOKID'||'...........'||'TITLE'||'...........'||'publisher'||'...........'||'Author');
  
  for i in c loop
  
  
    dbms_output.put_line(i.bookid||'...........'||substr(i.title,1,10)||'...........'||i.publishername||'...........'||concat(i.firstname||' ',i.lastname));
  
     end loop;
  
    end;
    /
  </code></pre>