How can I generate the DDL script for my object with DBMS_METADATA.GET_DDL without the schema name baked in?
If I do the following, everything is fine:开发者_开发问答 declare l_foo clob; begin select regexp_replace(
I\'d like to create ddl scripts for most of my database objects. dbms_metadata.get_ddl works for most of the object types. For instance the following creates the ddl for a view:
梵高有一幅画叫《星夜》，是《星空》。我常常在想，梵高在精神病院完成这幅杰作时开发者_StackOverflow，他眼中(或脑海中)的浩瀚星空该有多美，或该有多悲伤。可惜的是，我们永远只能看到画框里的小方块。
加载中,请稍侯......