Describe command in oracle

how to describe a table in oracle

how to describe a table in oracle sql developer

how to describe a table in oracle sql

how to desc table in oracle

Describe table in oracle example

Describe table in oracle w3schools.

Syntax

DESC[RIBE] {[schema.]object[@db_link]}

Lists the column definitions for the specified table, view or synonym, or the specifications for the specified function or procedure.

Terms

schema

Represents the schema where the object or permission to describe the object resides. If you omit schema and the object is not a public synonym, SQL*Plus assumes you own object.

Describe table in oracle not working

Oracle describe table invalid sql statement

Describe table in oracle w3schools

Describe table in oracle sql developer

Query to get table structure in oracle

object

Represents the table, view, type, procedure, function, package or synonym you wish to describe.

@db_link

Consists of the database link name corresponding to the database where object exists. For more information on which privileges allow access to another table in a different schema, refer to the Oracle Database SQL Language Reference.

Usage

The description for tables, views, types and synonyms contains the following information:

each column's name
whether or not null values are allowed (NULL or NOT NULL) for each column
datatype of columns, for example, CHAR, DATE, LONG, LONGRAW, NUMBER, RAW, ROWID, VARCHAR2 (VARCHAR), or XMLType
precision of columns (and scale, if any, for a numeric col