Home » SQL & PL/SQL » SQL & PL/SQL » retrieve a column content
retrieve a column content [message #235375] Sat, 05 May 2007 07:20 Go to next message
binnnu
Messages: 5
Registered: May 2007
Junior Member
i want see the content of a table of specific column i mean
suppose in emp table i want to see content of third column of emp table.
for this i have try like that
select (select column_name from user_tab_cols where column_id=3 and table_name='emp') from emp;

but i got column name in every not content.

[Updated on: Sat, 05 May 2007 07:33]

Report message to a moderator

Re: retrieve a column content [message #235381 is a reply to message #235375] Sat, 05 May 2007 07:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
you want to see just third columns data then use
"SELECT <COLUMN_NAME> FROM TABLE_NAME"

Regards
Taj
Re: retrieve a column content [message #235386 is a reply to message #235381] Sat, 05 May 2007 08:07 Go to previous messageGo to next message
binnnu
Messages: 5
Registered: May 2007
Junior Member
i want see content without using column name by column id
Re: retrieve a column content [message #235388 is a reply to message #235386] Sat, 05 May 2007 08:11 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
What do u mean by column id?
Re: retrieve a column content [message #235394 is a reply to message #235386] Sat, 05 May 2007 08:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But column id is meaningless, does not it?

See discussion in thread: http://www.orafaq.com/forum/m/235245/102589/#msg_235245

Regards
Michel
Previous Topic: Create table from two different tables [Merged]
Next Topic: SQL query help! group...
Goto Forum:
  


Current Time: Sun Dec 04 10:55:15 CST 2016

Total time taken to generate the page: 0.15162 seconds