Addin column, choose Byte/Char

If I add a column and choose varchar2 then Byte is always selected while we use Char.
There is also Default in the dropdown, but neither byte nor char is selected when I use that.'
Is it possible to have an option what to have preselected?

It should be defaulting to whatever is returned by this SQL:

Select value
from nls_session_parameters
where parameter = 'NLS_LENGTH_SEMANTICS'.

You can set this (or any ALTER SESSION command) automatically on login as shown below. Note, you can specify either asterisk for wildcard in the User/Database fields.

Thanks, that worked like a charm.

1 Like