7 Replies Latest reply on Apr 10, 2018 6:48 PM by mathguy

    How to remove double quotes when copying query result of dbms_metadata.get_ddl?

    2850698

      I'm using Oracle SQL Developer 17.2.0.188.

       

      I ran this statement select replace(dbms_metadata.get_ddl('INDEX', index_name),'"') from user_indexes by clicking Run Statement.

       

      When I copied the results from query results windows, the copied text for each row is enclosed with double quotes.