Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

View field in table Oracle 8i

Posted on 2004-09-20
8
Medium Priority
?
929 Views
Last Modified: 2012-05-05
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
Comment
Question by:Kerbeross
8 Comments
 
LVL 11

Expert Comment

by:sujit_kumar
ID: 12100397
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
 

Author Comment

by:Kerbeross
ID: 12101042
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 12101106
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Kerbeross
ID: 12101164
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
 
LVL 7

Accepted Solution

by:
Bigfam5 earned 375 total points
ID: 12101214
Do you know what the table_name is

DESC table_name

0
 

Author Comment

by:Kerbeross
ID: 12102173
But what about my second question?
0
 
LVL 11

Expert Comment

by:sujit_kumar
ID: 12733575
use, set pause on
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question