OPAC views:-
An opaque view is in the physical layer a physical table that consists of a Select statement .
In the repository, opaque views appear as tables in the physical layer but the view does not actually exist.
Only repository variables can be used in the definition. An error will generate if a session variable is
used in the view definition.
Syntax:
CREATE VIEW <view name> AS <select statement>,
An opaque view is in the physical layer a physical table that consists of a Select statement .
In the repository, opaque views appear as tables in the physical layer but the view does not actually exist.
Only repository variables can be used in the definition. An error will generate if a session variable is
used in the view definition.
Syntax:
CREATE VIEW <view name> AS <select statement>,
No comments:
Post a Comment