Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
PLSQL 1
« Previous
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
« Previous
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲