Bob swift (SQL for Confluence): How to set new nls_date_language as default?

Question

In the initialSQL<n> we must set the NLS_DATE_LANGUAGE, so that the ISO-week is not "American", but "German" (we need to start the week on Monday, not Sunday).

So prior to every SQL, we have to set the following to change it:

alter session set NLS_DATE_LANGUAGE = 'GERMAN'

Is there a way to set that as default?

Bob Swift · Answer

Yes, you can add things like this to a customized profile - see Data Source Profiles. Here is a related reference that shows you the techniques you can use - How to implement role based security for SQL queries.

Reece Bailey · Answer

Bob swift has its own Q & A at: https://bobswift.atlassian.net/wiki/cq/askquestion.action

I've found them to be very responsive in the past.