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?


      I'm using Oracle SQL Developer


      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.