View field in table Oracle 8i

I presume you want to see the information regarding all the coulmns of table in your schema. You can do that by,

SELECT * FROM USER_TAB_COLUMNS;

  I have no idea of viewing field/file contents. Are you taking about Database files like that of Access?


Regards...
Sujit

I run the command "SELECT * FROM USER_TAB_COLUMNS;" but what I found was it view a very long list of table schema. I just want to view a row so that I can know what field is in it.

then try to filter out using LIKE oper



SELECT * FROM USER_TAB_COLUMNS where column_name like '%string%' ; --replace the string with the one you really want to see...

actually I don't know what's the column name. my purpose here is to see the column name, only then display the data inside.

But what about my second question?

use, set pause on