DBA Data[Home] [Help]

VIEW: HR.HR_NAME_FORMATS#

Source

View Text - Preformatted

select NAME_FORMAT_ID NAME_FORMAT_ID, FORMAT_NAME FORMAT_NAME, LEGISLATION_CODE LEGISLATION_CODE, USER_FORMAT_CHOICE USER_FORMAT_CHOICE, FORMAT_MASK FORMAT_MASK, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."HR_NAME_FORMATS"
View Text - HTML Formatted

SELECT NAME_FORMAT_ID NAME_FORMAT_ID
, FORMAT_NAME FORMAT_NAME
, LEGISLATION_CODE LEGISLATION_CODE
, USER_FORMAT_CHOICE USER_FORMAT_CHOICE
, FORMAT_MASK FORMAT_MASK
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."HR_NAME_FORMATS"