How can I export only the structure of a table using PL/SQL?

In PL/SQL, the DBMS_METADATA.GET_DDL function can be used to export the structure of a table. Here is an example code:

DECLARE
   v_ddl CLOB;
BEGIN
   -- 通过指定对象类型和对象名称来导出表的结构
   v_ddl := DBMS_METADATA.GET_DDL('TABLE', 'your_table_name');
   
   -- 输出DDL语句
   DBMS_OUTPUT.PUT_LINE(v_ddl);
END;
/

In the code above, replace “your_table_name” with the name of the table whose structure you want to export. After running this code, it will print the DDL statement of the table, which includes the table’s structure information.

Note: The above code will only export the structure of the table, not the data. If you need to export the data from the table, you can consider using the SELECT statement and SPOOL command to export the data to a file.