noobie question ;) datatype

DB: oracle 8i
tool: SQL*Plus Worksheet (standart from oracle cd)

ok first my problem:
tbale has a column named "user_data" data type is "msg_bws_ld"(i know that it must be the secret core of my problem)
ok
if i do a select
select user_data from table_name;

i get this:
user_data(aaa, bbb, ccc, ddd, eee)
------------------------------------
msg_bws_ld(123, 'h4-s', '300342B6', thi, 592)

300 lines of this stuff
so how do i select only that lines where "bbb= 'h4-s'"


ps: hope you can understand my english ;)

I don't understand.

You say USER_DATA is a column name and when you select result set look odd to me and you want to filter by bbb=h4-s, you can only do this if bbb is a column in USER_DATA table

there is no user_data table... :(


why do i get the data type for every line? if data type is number it is not displayed.

user_data(aaa, bbb, ccc, ddd, eee)
------------------------------------
msg_bws_ld (123, 'h4-s', '300342B6', thi, 592)



thx for help :)
when i have found the solution i´ll post it.