DESCRIBE COMMAND

Oracle server stores information about all table in special set of relation table called data dictionary. Data dictionary is similar to a regular language dictionary it stores definition of objects, orderedand structure format. Definition of table name include table name, table owner, details about column, physical storage size on disk this information is known as metadata. Content of tables are stored as rows they are referred as data. Structure of metadata of a table can be obtained using query called DESCRIBE COMMAND.

§  Syntax: Desc tablename;
§  Example: Desc employee;




Here name, null & types are meta data and employee_id,  job_id etc.. are cloumns/fields of employee table.

Previous
Next Post »