Results 1 to 2 of 2

Thread: Reports?

  1. #1
    Join Date
    May 2004

    Unanswered: Reports?

    Say I wanted to create a report for the table

    create table booking
    (Booking_Number number PRIMARY KEY,
    Name char(20) not null,
    Phonenumber varchar(20) not null,
    RoomType varchar2(2) not null,
    Date_of_Arrival date not null,
    Duration_of_Stay number,
    SpecialRequirements varchar2(30));

    What would be the best way to do it?(Using code only) also anyone know where I can find some tutorials on this?


  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1
    You need to decide on what tool you will use to write the report. For a simple report this could be SQL Plus (which everyone has):

    SQL> select * from booking order by booking_number;

    There are various formatting options.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts