How Can I View the Table Definition in Oracle SQL, Similar to MySQL's `SHOW CREATE TABLE`?

Oracle's Equivalent to MySQL's show create table

In MySQL, the show create table command allows users to retrieve the definition of a table, including its columns and data types. Is there an analogous functionality for Oracle SQL?

Yes, Oracle SQL offers several methods to accomplish this:

• Using SQL*Plus Commands:

  The desc command in SQL*Plus provides a table's definition in a format similar to show create table.

  SQL> desc emp

• Utilizing the dbms_metadata package:

  The dbms_metadata.get_ddl() function within the dbms_metadata package returns the DDL for a specified table.

  select dbms_metadata.get_ddl('TABLE', 'EMP', 'SCOTT') from dual;

Note: To display LOBs that may exceed the default length limit, consider executing set long 10000 in SQL*Plus. This extends the number of bytes displayed to 10,000, but it can be adjusted to a higher value if necessary.

The above is the detailed content of How Can I View the Table Definition in Oracle SQL, Similar to MySQL's `SHOW CREATE TABLE`?. For more information, please follow other related articles on the PHP Chinese website!