DBA Data[Home] [Help]
Skip to content

VIEW: HR.HR_PATTERNS#

Source

View Text - Preformatted

select PATTERN_ID PATTERN_ID, PATTERN_NAME PATTERN_NAME, PATTERN_START_WEEKDAY PATTERN_START_WEEKDAY, PATTERN_START_TIME PATTERN_START_TIME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE from "HR"."HR_PATTERNS"
View Text - HTML Formatted

SELECT PATTERN_ID PATTERN_ID
, PATTERN_NAME PATTERN_NAME
, PATTERN_START_WEEKDAY PATTERN_START_WEEKDAY
, PATTERN_START_TIME PATTERN_START_TIME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "HR"."HR_PATTERNS"