To track Tables and Columns from Backend

To track Tables and Columns from Backend

To know the Object Name (Object can be anything like Package, Procedure, Function, Table, View or synonym name etc), to check whether that object exist in the database or not. If exist then, is it active or what is the owner of object etc.
All the details can be found from the following select statement.

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = 'your object name';

To know the table name and from backend and to know the column name, data_type, date_length etc of the given table. use the following Query.

SELECT column_name,data_type,data_length FROM dba_tab_columns
WHERE table_name = 'Your Table Name';