find the 3rd column (all the data along with column name) in a table

Question

1.00/5 (1 vote)

See more:

SQL

Oracle

hi,
I have to find the 3rd column of a table Person. i dont know the column name.

thank you in advance

Posted 9-Feb-12 4:03am

chinta123

Add a Solution

Comments

Nandakishore G N 9-Feb-12 10:09am

can.You explain little.more?

chinta123 9-Feb-12 10:50am

hi,I have a table name called person and there is 3 columns FirstName,LastName,Age ,I dont know the column name,but i only know there are 3 columns ,i have to extract the 3 rd column name and also the data .

Sergey Alexandrovich Kryukov 9-Feb-12 14:08pm

This is not how SQL and relationship databases work.
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2012-02-09T04:15:00

Solution 1

If you select all the data, and move to the third colum in the construct that contains it, then you can find the data in the third column.

This[^] is apparently how you find column names. Note: I don't use Oracle, I just know how to google.

Posted 9-Feb-12 4:15am

Christian Graus

Comments

chinta123 9-Feb-12 10:51am

Can u please tell me briefly,so that i can understand and please give an example.

Jörgen Andersson 9-Feb-12 16:16pm

The link Christian gave you is correct. Run: SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name ='My_Table';
The third row in the resultset is the data for the third column in your table.

Christian Graus 9-Feb-12 10:52am

As I said, I don't use Oracle, I just know how to use Google. That page, I found with google, explains how to find out the columns in a table. That's what you want to do, isn't it ?

Sergey Alexandrovich Kryukov · Answer 2 · 2012-02-09T08:13:00

As I say, this is not how SQL and relationship data bases work. You need to know a column. However, you can learn what columns are there in your table.

For example, look at this answer:
http://forums.sureshkumar.net/oracle-sql-server-sybase-others/22736-sql-query-find-column-names-table.html[^].

The idea is getting meta-data from the Oracle system table, in this example, all_tab_cols.

See also:
http://en.wikipedia.org/wiki/Metadata[^],
http://en.wikipedia.org/wiki/Database_schema[^].

—SA