Creating Report using oracle

Reya

Reya

@reya-SMihdC • Oct 21, 2024
hi friends can somebody tell me how to create a report using oracle?
Like 0 Replies 5

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • Manish Goyal

    Manish Goyal

    @manish-r2Hoep • Mar 14, 2010

    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
    0
  • Sahithi Pallavi

    Sahithi Pallavi

    @sahithi-oJZaYj • Mar 14, 2010

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

    Mahesh Dahale

    @mahesh-E2tZ3t • Mar 14, 2010

    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"
    0
  • Manish Goyal

    Manish Goyal

    @manish-r2Hoep • Mar 14, 2010

    oops sorry for misinterpretation
    0
  • Sahithi Pallavi

    Sahithi Pallavi

    @sahithi-oJZaYj • Mar 15, 2010

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