how to change the date format using initSQL from weblogic console
Last updated on MARCH 01, 2017
Applies to:Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.
How to enable the feature of Initializing Database Connections with SQL Code
As documented in "https://docs.oracle.com/middleware/1212/wls/JDBCA/jdbc_datasources.htm#JDBCA159", WebLogic Server runs SQL code using Init SQL attribute on the JDBC Data Source: Configuration: Connection Pool page in the Administration Console whenever it creates a database connection for the data source, which includes at server startup, when expanding the connection pool, and when refreshing a connection.
But This feature did not work for the below query
SQL alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
The same feature is working for Oracle forms and Reports
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms