Hello out there,
I think, this has been asked before, but I did not find that posting anymore.
When viewing the DDL of a table I see something like this to be executed:
declare
FUNCTION ifelse (bool_in IN number) RETURN boolean IS
BEGIN
IF bool_in = 0 THEN
RETURN false;
ELSE
RETURN true;
END IF;
END;
begin
DBMS_METADATA.SET_TRANSFORM_PARAM(dbms_metadata.SESSION_TRANSFORM, 'SEGMENT_ATTRIBUTES', ifelse(:SEGMENTS));
DBMS_METADATA.SET_TRANSFORM_PARAM(dbms_metadata.SESSION_TRANSFORM, 'PARTITIONING', ifelse(:PARTITIONING));
DBMS_METADATA.SET_TRANSFORM_PARAM(dbms_metadata.SESSION_TRANSFORM, 'TABLESPACE', ifelse(:TABLESPACE));
dbms_metadata.set_transform_param(dbms_metadata.SESSION_TRANSFORM, 'SQLTERMINATOR', ifelse(:TERMINATOR));
dbms_metadata.set_transform_param(dbms_metadata.SESSION_TRANSFORM, 'PRETTY', ifelse(:PRETTY));
DBMS_METADATA.SET_TRANSFORM_PARAM( dbms_metadata.SESSION_TRANSFORM, 'SIZE_BYTE_KEYWORD', ifelse(:BYTE));
DBMS_METADATA.SET_TRANSFORM_PARAM( dbms_metadata.SESSION_TRANSFORM, 'FORCE', ifelse(:FORCE));
DBMS_METADATA.SET_TRANSFORM_PARAM( dbms_metadata.SESSION_TRANSFORM, 'EMIT_SCHEMA', ifelse(:SHOWSCHEMA));
DBMS_METADATA.SET_TRANSFORM_PARAM( dbms_metadata.SESSION_TRANSFORM, 'CONSTRAINTS', ifelse(:CONSTRAINT));
DBMS_METADATA.SET_TRANSFORM_PARAM( dbms_metadata.SESSION_TRANSFORM, 'REF_CONSTRAINTS', ifelse(:REF_CONSTRAINT));
DBMS_METADATA.SET_TRANSFORM_PARAM( dbms_metadata.SESSION_TRANSFORM, 'CONSTRAINTS_AS_ALTER', false);
end;
Now the question is, can these variables be set in the preferences?
What I want to achieve is removing the schema, the double quotes and the segment attributes.
Can this be configured somewhere.
I use SQL Developer 23.1.1.345
Kind regards.