Solved

View field in table Oracle 8i

Posted on 2004-09-20
8
921 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Convert Oracle data into XML document 2 54
PL/SQL - Leading zeros 7 56
sql query 9 37
Performance issue with case statement in oracle 11G 7 45
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now