DBA Data[Home] [Help]

VIEW: QA.QA_DEVICE_INFO#

Source

View Text - Preformatted

select DEVICE_ID DEVICE_ID, DEVICE_NAME DEVICE_NAME, DESCRIPTION DESCRIPTION, SENSOR_ALIAS SENSOR_ALIAS, PULL_FREQUENCY PULL_FREQUENCY, ELAPSED_TIME ELAPSED_TIME, OVERRIDE_FLAG OVERRIDE_FLAG, ENABLED_FLAG ENABLED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY from "QA"."QA_DEVICE_INFO"
View Text - HTML Formatted

SELECT DEVICE_ID DEVICE_ID
, DEVICE_NAME DEVICE_NAME
, DESCRIPTION DESCRIPTION
, SENSOR_ALIAS SENSOR_ALIAS
, PULL_FREQUENCY PULL_FREQUENCY
, ELAPSED_TIME ELAPSED_TIME
, OVERRIDE_FLAG OVERRIDE_FLAG
, ENABLED_FLAG ENABLED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "QA"."QA_DEVICE_INFO"