-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|