Just a short tip on how to retrieve the Column Name and the related Data Type with SQL. Simply issue the following SQL within Oracle:
select column_name, data_type
from all_tab_columns
where table_name = ‘YOURTABLENAME’
This will return you a output with the column name and the data type for it. Remember that Oracle is case sensitive and the table names are all in uppercase in your where select for the table!
If you enjoyed this post, make sure you subscribe to the RSS feed!
wht in sql server 2000 need help plz rply soon
SQL Server uses stored procedures for this (or something like this). I have found the following link for this over at Microsoft. Hope this helps.
I have a dbCFC component that currently uses this functionality and is available to download and extend if users would like to.
http://dbcfc.googlecode.com
Cheers.