NLS Masks WIth Extension

User_6BTKC

Hi All,

Maybe I am just missing something in how the extension works. Here's the situation. In one of the databases I work with (11c in this case) the default NLS Date Format is DD-MON-YY. In the extension if i right click that database and open a new scrap SQL file and do a simple query like:

SELECT some_date_field FROM some_table;

The output comes back in MM/DD/YYYY HH:MI:SS

If I alter session alter session set nls_date_format='YYYY-MM-DD:HH:MI:SS';  or really anything and re-execute the query the results stay in this same format. Is there no way to utilize NLS_DATE_FORMAT in the extension? Maybe some setting I am missing?

Christian.Shay -Oracle

Hi and thanks for the feedback!

This issue is fixed in the next release (version 19.3.4) which is coming out very soon. Please keep an eye out and give it a try and let me know here if it solves your problem.

Christian.Shay -Oracle

Hi and thanks for the feedback!

This issue is fixed in the next release (version 19.3.4) which is coming out very soon. Please keep an eye out and give it a try and let me know here if it solves your problem.

User_6BTKC

<3 I am very excited for the new release thanks for the info

Christian.Shay -Oracle

Hi,

We just released version 19.3.4 which should fix this issue. Could you please try it out and let me know?

User_6BTKC

Just did and it is absolutely working both in the tabular output as well as if i save to CSV. I'll check out the other updates as well. Nice one guys.

Ray007

Is there a way to set the default NLS so I don't need to alter my session each time?

Christian.Shay -Oracle

https://community.oracle.com/tech/developers/discussion/comment/16797178#Comment_16797178

No, not through these tools... you could set up a login trigger in the database.

We are looking into a "login.sql" sort of solution that would solve this problem.

Ray007

Thanks. For now I created a bookmark that I can just run when I need it.

Christian.Shay -Oracle

In version 21.5 we added support for a login script which should make changing NLS settings a lot easier :)

Ray007

Thanks. Pointed to my instant client's glogin.sql file and works perfect. Next, someone will ask for this to be set per connection.... LOL (I'm good with this).

Christian.Shay -Oracle

https://community.oracle.com/tech/developers/discussion/comment/16848544#Comment_16848544

Actually, you can set it per connection. Check the "Show more Options" checkbox in the connection dialog and set the login script field that appears. (You can "Update" an existing connection to bring up the connection dialog.)