Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 932
  • Last Modified:

View field in table Oracle 8i

Hi...
I want to view field list in file of Orable 8i db. How?
Also, how can I view field/file content by page?
Thanks.
0
Kerbeross
Asked:
Kerbeross
1 Solution
 
sujit_kumarCommented:
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
0
 
KerberossAuthor Commented:
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.
0
 
seazodiacCommented:
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...
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
KerberossAuthor Commented:
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.
0
 
Bigfam5Commented:
Do you know what the table_name is

DESC table_name

0
 
KerberossAuthor Commented:
But what about my second question?
0
 
sujit_kumarCommented:
use, set pause on
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now