Sunday, January 15, 2017

SQL Query To Find Out Attribute Values Of A Workflow:




SQL Query To Find Out Attribute Values Of A Workflow:
SELECT NAME attr_name,
       nvl(text_value,
           nvl(to_char(number_value),
               to_char(date_value))) VALUE
  FROM wf_item_attribute_values
 WHERE item_type = upper('&item_type')
   AND item_key = nvl('&item_key',
                      item_key)
/

No comments:

Post a Comment

If your Chrome browser is opening new tabs with random content

If your Chrome browser is opening new tabs with random content, it may be due to adware, a browser hijacker, or an extension that you didn...