My Oracle Support Banner

SAS Label Value Changed while Creating a View In LSH (Doc ID 2674512.1)

Last updated on JULY 03, 2020

Applies to:

Oracle Life Sciences Data Hub - Version and later
Information in this document applies to any platform.


Select a source table that is including columns with SAS format set to "BEST32." and "DATETIME19.".

Create a target table from this source table by using a Program View.


In the target table, the SAS format for these columns is showing as "8." and "DATETIME" respectively.

It would be expected that the SAS format for these columns to be set as "BEST32." and "DATETIME19.", matching the format from source table.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.