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,