Is this possible with SQL in SQL PLUS?

From: johan <johan.volders_at_village.uunet.be>
Date: Thu, 30 Aug 2001 03:52:48 +0200
Message-ID: <3b8d9de3$0$7114$4d4efb8e_at_news.be.uu.net>

[Quoted] Every 5 minutes i want to save temperatures of a furnace in an Oracle table. [Quoted] The furnace = 60 meters long and every meter there is a registration of 2 temperatures (left side and right side).

[Quoted] So i store every five minutes 2 records in a table with fields date, L (= left side of furnace), temp1, temp2, .........., temp60 date, R (=right side of furnace), temp1, temp2, ........, temp60

When the user enters a date,time i want to show fields of the two records from that date,time in following format :

left temp1           right temp1
left temp2           right temp2
    ....                         .....
left temp60        right temp60

Is this possible with a simple query from sql plus or does one have to program in PL/SQL to accomplish this?

Friendly regards
Johan Received on Thu Aug 30 2001 - 03:52:48 CEST