Select Data from Attribute View

[Former Member]

I've created an Attribute view. 

I'd like to :-

(1) Access the view via 'command line' SQL - i.e. 'SELECT * from <Attribute View>'.  Cannot work out how to reference it.  I'd have guessed <package>.<view name> - however this does not work

(2) Where  can I view the text of the view - i.e. the code that was generated when the view was created?

Cheers,

Chris

[Former Member · Accepted solution]

Hi Chris,

Answers below:

(1) When you activate an attribute view, a column view gets generated behind the scenes under the schema "_SYS_BIC". To run SQL statements on it, you will have to reference the view as "_SYS_BIC"."<package>/<view_name>". Have a look at the _SYS_BIC schema under column views, you should be able to see your attribute view. Same holds true for analytic and calculation views as well.

(2) If you double-click or right-click->Open Definition on the appropriate column view under _SYS_BIC schema, the second tab on the screen that opens up has the sql statement that was generated.

Thanks,

Anooj

[Former Member · Accepted solution]

Anooj,

Thanks for the answer - spot on.

Cheers

Chris