Hi
How can I get the field names from the truncated (empty) oracle table?
Kika
The USER_TAB_COLUMS view contain the field names🙂
$query = "SELECT cname, colno FROM col WHERE tname = upper('$Table') ORDER BY colno";
desc YOURTABLE --desc is short for describe