Skip to Main Content

SQL & PL/SQL

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!

Alter session statement in View

User_JZKI6Jun 22 2021

Hi Everyone,
Actually we created view for calculating the business Hrs and Minutes between 2 dates from the main table. View will show the data in date format, after alter session we could see in Hrs and Min format.
For few of the records there was difference in Hrs and Minutes count before and after altering the session. How Can we include the below alter statement when we crating the view for showing unique values.
alter session set nls_date_format='YYYY-MM-DD HH24:MI';
when we are trying to create view including alter facing issues.
Oracle Sql version we are using : Version 20.2.0.175

Thanks,

Comments
Post Details
Added on Jun 22 2021
4 comments
1,284 views