Latest Activity

code

Clickable link in the view description

Hello people, I have a question about the view description. Is it possible to add a clickable link into the description of a view? Or is there are another place in the view that I can add a link for an external page?

Base View descrptions COLUMN_DESCRIPTION descriptions

code

Add Column Description doesn't work with UNION

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = 'xxx' (columnname (DESCRIPTION = 'xxx')), it will give me an error saying the firl...

COLUMN_DESCRIPTION UNION

code

Add Column Description doesn't work with UNION when appending record

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = ‘xxx’ (columnname (DESCRIPTION = ‘xxx’)), it will give me an error saying the firl...

COLUMN_DESCRIPTION UNION

code

how to do the transpose columns to rows as two separate columns

Hi All, I have to do transpose data columns to rows like below currently data is showing like this: ID date Q1 Q2 1 01-03-2020 00:00 6 9 2 13-03-2020 00:00 7 8 Expected output: ID date Questions Answers 1 01-03-2020 00:00 Q1 6 2 01-03-2020 00:00 ...

DENODO COLUMN_DESCRIPTION

code

Display column description INSTEAD of column name

When building views for our business I want to display COLUMN_DESCRIPTION not column names in my views and reports. How can I display COLUMN_DESCRIPTION instead of COLUMN_NAMES in views derived from iv_views?

COLUMN_DESCRIPTION