Solved

View field in table Oracle 8i

Posted on 2004-09-20
8
925 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Industry Leaders: 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 125 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
scheduler notification 9 79
Oracle Mulit-site configuration 28 73
Oracle cluster . 1 24
Oracle SQL-Queries on a RAC Database 3 46
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ā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

734 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