SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Peter CheungApr 6 2018 — edited Apr 10 2018

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2018

Added on Apr 6 2018

#sql-developer

7 comments

6,932 views