How to extract DDL of objects in oracle adtabase?

set heading off echo off  pages 999 long 9999999 trimspool on


select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;
 select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;
select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces