Which command is used to describe more complex picture of object table?

Options
- SET DESCRIBES
- SET DESCRIBE
- DESCRIBES
- ALL


CORRECT ANSWER : SET DESCRIBE

Discussion Board
SET DESCRIBE

The SET DESCRIBE setting controls the depth to which an object such as an object type or object table is described. It is used to describe more complex picture of object table.
Syntax:
SET DESCRIBE [DEPTH {levels | ALL}] [LINENUM {ON | OFF}] [INDENT {ON | OFF}]

where,
DEPTH {levels | ALL} : It specifies the depth to which to recursively describe an object. The default is to describe only the top level of columns, attributes, or parameters.

LINENUM {ON | OFF} : It adds or removes line numbers from the object's description. The default is LINENUM OFF.

INDENT {ON | OFF} : It indents nested descriptions. The default is INDENT ON.

Prajakta Pandit 02-21-2017 11:38 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement