SQL*Plus

[sangeetailor]

I have the following table;

Name Null? Type
----------------------------------------- -------- ----------------------------
RDATE DATE
ROOM_NO VARCHAR2(2)
SESSION_B VARCHAR2(9)
BEVERAGE VARCHAR2(10)
QTY NUMBER(3)
TIME DATE


If i wanted to do a select statement, to show all entries in the table, with the Time displaying as an actual time
would I have to put all of the fields into the select statement?

I've used the following:

select rdate, room_no, session_b, beverage, qty, to_char(time, 'hh24:mi') from BEVERAGE_BOOKING;

Is there any other way of performing this operation?