Timeline for How to get the DDL for Oracle object without extra characters
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 15, 2022 at 10:05 | answer | added | ildar | timeline score: 0 | |
| May 18, 2016 at 18:44 | comment | added | Raj | I am guessing you may not be able to directly get rid of those 3 characters and double-quotes easily. These probably get added when xml to ddl transformation happens (dbms_metadata first generates xml and transforms it to ddl or sxml if requested). Because if you use dbms_metadata.get_xml, you don't see those characters, but you see them for get_ddl(). a substr(...get_ddl(),4) could fix that. You have to be careful about double quotes though. | |
| May 12, 2016 at 15:29 | answer | added | Osho | timeline score: 1 | |
| May 11, 2016 at 11:57 | comment | added | Phil Sumner | Looking at the comments below and here, I think that you may be trying to do something in a slightly backwards fashion. Can you explain what it is you want to achieve, then someone may be able to provide a better way to manage it. | |
| May 10, 2016 at 10:59 | answer | added | BriteSponge | timeline score: 1 | |
| May 10, 2016 at 10:22 | comment | added | BriteSponge | The double quotes are there to allow for the possibility that you created the procedure using a reserved word or containing a non-standard character. | |
| May 10, 2016 at 10:14 | history | asked | LiborStefek | CC BY-SA 3.0 |