getting column names and data type
-
Can anyone tell me having known the table name, how can I get the column names and their datatype? I am using the ojdbc14 driver to connect to my Oracle10g database. My table name is 'orders' and I want to know how many columns it has and of what type. Is there any query for this?
-
Can anyone tell me having known the table name, how can I get the column names and their datatype? I am using the ojdbc14 driver to connect to my Oracle10g database. My table name is 'orders' and I want to know how many columns it has and of what type. Is there any query for this?
-
to know the column names: select COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='orders' all the related information would be present when you use select * from information_schema.columns try it out!!
Gautham
Good !!!! :rose:
Pavan Pareta