Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 31st, 2005, 09:21 AM
Authorized User
 
Join Date: May 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to saravananedu
Default how to Retrieve Column Names Using SQL Query

hi,

we can use desc[ribe] attribute to list down the columns of the table. but Is there any way to retrieve column names of a table using sql query?

thanks in advance,
saran.
__________________
Best Regards,
Saran.
 
Old September 9th, 2005, 09:05 AM
Registered User
 
Join Date: Feb 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to SureshHyd
Default

Use System view user_tab_columns to fetch the required info.

Select column_name, data_type from user_tab_columns where table_name = 'urtablename'
 
Old September 10th, 2005, 01:57 AM
Authorized User
 
Join Date: May 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to saravananedu
Default

Thanks Suresh,

   Its working fine. Thanks a lot once again.

   suresh...could u do one more help for me?

   How to store & retrieve value from number(20,2) in oracle. for ex. i neet an output as 123456789012345678.99 but im getting only 1.23456789012346E17.

   kindly check my new post (P2P Forum > Database > Oracle > Number(20,2) Rounding off Problem) for detail and help me. thanks a lot.

Best Regards,
Saran.

Best Regards,
Saran.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic column names in crystal reports pankaj_daga Crystal Reports 3 January 19th, 2009 02:55 AM
Column names! Help! dirtdog22 Access VBA 6 June 1st, 2007 06:37 AM
Query for Column Names and Datatypes rstelma SQL Server 2000 3 August 23rd, 2005 02:52 PM
Retrieve the table names from union query. udayanbi Access 0 July 20th, 2005 01:38 AM
How to Retrieve Table Names using ADO ramk_1978 ADO.NET 1 October 22nd, 2004 08:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.