Find a DDL and DML queries of particular OWNER ans TABLE

Find a DDL and DML queries of particular OWNER ans TABLE


SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner) FROM all_OBJECTS WHERE (OWNER = 'OWNER1');


SELECT DBMS_METADATA.GET_DML(object_type, object_name, owner) FROM all_OBJECTS  WHERE (OWNER = 'ASUB');

find the insert query

select 'INSERT INTO QP_BANK_INFO values(''' || Name || ','|| AGE ||',''' || Address ||''');' from QP_BANK_INFO;

 change the column names of a table