Include decode in designer snapshot definition
Posted on 2004-08-12
I am using oracle designer ver 184.108.40.206.0. Server is 8.1.7.
I am setting up a view (that uses multiple snapshots).
The view is defined using the free format view definition.
Is it possible for me to put a decode statement on one of the
columns of the view or underlying snapshots? If it is possible, how
exactly do I go about that in designer?
Also, is it possible for me to specify complete refresh of a
snapshot? How do I do that in designer (again, not editing sql)?
Keep in mind, I am trying to avoid editing the .sql code,
I am trying to include these things in the designer definition
of my object - snapshots/views.
Thanks for any info,