SQLzoo.net

What are the columns of the cia table?

Oracle
	SELECT * FROM all_tab_columns WHERE table_name='CIA'
Specific to Oracle
When working with the sqlplus interface you can simply ask DESCRIBE cia; Notice that the table name is in upper case. See also USER_TAB_COLUMNS Manual page.