DESCRIBE
DESC[RIBE] [schema.]object_name [@database_link_name]
The DESCRIBE command is used to display information about a table, a view, an Oracle8 object type, a stored package, a stored procedure, or a stored function. For example:
DESCRIBE employee DESCRIBE jenny.employee DESCRIBE employee@other_db