Creating Report using oracle

Replies

• 

  Manish Goyal

  you can write features of oracle,introduction of oracle which consists of why?what? ,it's scope
  
  Then you can proceed with some case studies take some example ie library management
  
  ,hotel management and create a database
• 

  Sahithi Pallavi

  @goyal : I think praveena is not asking about a report on oracle, its a report using oracle.
  Is'nt it?
• 

  Mahesh Dahale

  SQL> create table BOOKSHELF_CHECKOUT (name varchar2(15),title varchar2(15),checkoutdate date,returneddate date);
  
  
  Open notepad
  
  Rem bookshelf
  Set headsep !
  Ttitel ‘ Oracle Report’
  Btitle’ CE‘
  Column name format a20
  Column title format a20 word_wrapped
  Column dayout format 999.99
  Column dayout heading ‘day!out’
  Break on name skip 1 on report
  Compute avg of dayout on name
  Compute avg of dayout on report
  
  Set linesize 80
  Set pagesize 60
  
  Spool activity.1st
  Select name,checkoutdate,returnedate,
  Returneddate-checkoutdate as dayout/*count days*/
  From BOOKSHELF_CHECKOUT
  Order by name:
  
  Spool off
  
  
  save this file ".sql"
• 

  Manish Goyal

  oops sorry for misinterpretation
• 

  Sahithi Pallavi

  Nice work mahesh!
  And I dont know anything about it. 😔