This is how to query an Oracle database for Table and Column information. Obviously, you can change these statements to work for what you need.
SELECT TABLE_NAME
FROM USER_TABLES
ORDER BY TABLE_NAME;
SELECT U.TABLE_NAME,
U.COLUMN_NAME,
U.DATA_TYPE
FROM USER_TAB_COLUMNS U
WHERE U.TABLE_NAME = '<Table Name>'
ORDER BY U.COLUMN_ID;