What are the two ways to determine the structure of a table in database?

Options
- Using DESCRIBE command and dbms_metadata_get_commit package
- Using METADATA command STRUCTURE commands
- Using DATA_ON_DATA and STRUCTURE commands
- Using DESCRIBE command and dbms_metadata.get_ddl statement


CORRECT ANSWER : Using DESCRIBE command and dbms_metadata.get_ddl statement

Discussion Board
probably a typo

There is no dbms_metadata_get_ddl package. There is dbms_metadata package and get_ddl() function. ( dbms_metadata.get_ddl() )

Nick 08-21-2014 03:28 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