Home » SQL & PL/SQL » SQL & PL/SQL » (Urgent !!!) Row to column
(Urgent !!!) Row to column [message #35845] Fri, 19 October 2001 01:46
yopy
Messages: 1
Registered: October 2001
Junior Member
Hi guys,

i am need a help to change row data to column data
using SQL

for example i have query table like this :

date_stamp start_time tag_name tag_value
---------- ---------- -------- ---------
07-sep-01 20:00:00 A 1
07-sep-01 20:00:00 B 2
07-sep-01 20:00:00 C 3
07-sep-01 21:00:00 A 4
07-sep-01 21:00:00 B 5
07-sep-01 21:00:00 C 6

and i want to be like this

date_stamp tag_name 20:00:00 21:00:00
---------- -------- -------- --------
07-sep-01 A 1 4
07-sep-01 B 2 5
07-sep-01 C 3 6

so, what do i have suppose to do ?

regards

yopy

----------------------------------------------------------------------
Previous Topic: HELP! writing back in table
Next Topic: wait for database entry in pl/sql
Goto Forum:
  


Current Time: Thu Mar 28 23:38:04 CDT 2024