Skip to Main Content
Forums

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS Masks WIth Extension

User_6BTKCMar 10 2021

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?
This post has been answered by Christian.Shay -Oracle on Mar 10 2021
Jump to Answer

Comments

Answer

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.

Marked as Answer by User_6BTKC · Jun 24 2021
1 person found this helpful
User_6BTKC

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

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?

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.

1 person found this helpful
Ray007

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

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

1 person found this helpful
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).

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.)

1 person found this helpful
1 - 10

Post Details

Added on Mar 10 2021
#oracle-developer-tools-for-vs-code
10 comments
131 views