DB version : 11.2
What is the recommended way to remove all the double from the below output ? In the bottom, I have mentioned the reason why I need this.
SQL> create table t1 ( somestring clob);
Table created.
SQL> insert into t1 values ('"helloworld"');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t1;
SOMESTRING
--------------------------------------------------------------------------------
"helloworld"
SQL>
Why I need this :
I want to remove the double quotes from the output DBMS_METADATA.GET_DDL as shown below. This function returns a CLOB type.
I want to see the object DDLs in lower case But object names in lower case enclosed in double quotes causes trouble
set long 32767 pages 0 lines 256
set trimspool on
column line format A254 WORD_WRAPPED
select lower (dbms_metadata.get_ddl(object_type => 'TABLE', name => 'EMP', schema => 'SCOTT')) line from dual ;
create table "scott"."emp"
( "empno" number(4,0),
"ename" varchar2(10),
"job" varchar2(9),
"mgr" number(4,0),
"hiredate" date,
"sal" number(7,2),
"comm" number(7,2),
"deptno" number(2,0),
constraint "pk_emp" primary key ("empno")
.
.
.
<snipped>