Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to get the 3rd column(i.e all the data along with the
column name)in a table?

Answer Posted / ramesh

Column Names of a table are stored in the data dictionary
table user_tab_columns along with column_id. By referring
column_id we can display the column name as :

select column_name from user_tab_columns where table_name
= 'EMP' and column_id = 3;

Is This Answer Correct ?    10 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rollback truncate?

1010


What is pls integer?

1054


what is transaction? : Sql dba

1018


What is left join in postgresql?

1057


How do I add a primary key to a table?

1049


Why is sql important?

1117


What does joining a thread mean?

1027


What is a temp table?

1034


What is the difference between functions, procedures, and packages in pl/sql?

1062


What are all the different normalization?

1050


when MSQL8.0 is in market

2091


What operating systems are supported by oracle sql developer?

975


What is an invalid partition table?

1035


What is mdb stand for?

1018


How do I make my sql query run faster?

951