Using metadata

pl/sql block which helps us in getting DDL easily for many database objects.
example:
begin
for objects in
(select object_name,owner,object_type
from dba_objects
where owner=’&schema_name’ and object_type='INDEX'
)
loop
dbms_output.put_line(dbms_metadata.get_ddl(objects.object_type,objects.object_name,objects.owner));
end loop;