This content has been marked as final. Show 2 replies
You could use the OraMetaData interface to describe a schema object, such as a table, before or after issuing the SELECT * to get the column names. See the example in the online help.
You should use the fields collection, in the OraDynaset object.
All you need to do is :
for i = 0 to Recordset.Fields.Count -1
debug.print Recordset.Fields(i).OriginalName 'this will print the field's name before an alias