Menu
I have created 8 different views and i am using all these views inside a view. So i was wondering before i go any further with this idea. i want to know does it affects performance too badly or not.
419
Note: You can place a view reference on other views. If you try to reference the current view on a sheet, no symbol is placed. Open the view to which you want to add a reference. Note: If the view is on a sheet, right-click the view, and click Activate View.
You can certainly have a view that's built on top of another view: create table my_table (id number, name varchar2(20), address varchar2(30)); table MY_TABLE created.
Creating ViewsViews can be created from a single table, multiple tables or another view. To create a view, a user must have the appropriate system privilege according to the specific implementation. CREATE VIEW view_name AS SELECT column1, column2..... FROM table_name WHERE [condition];
Views – pitfallsThe chief risk coming when one view refers to another which in turn refers to another – this is known as a nested view and to your grizzled DBA sets the alarm bells ringing.
No, it's fine. In many cases I personally consider it preferable to writing one view with a giant and difficult to understand definition. In my opinion, using multiple views allows you to:
112
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
