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