A VIEWS takes memory in the database.
If yes, how can u proove it?
is there any way to display the size of views?
Answer / kriish
Views do no take memory in database they are just window through data is shown to user from table
| Is This Answer Correct ? | 17 Yes | 2 No |
What is the difference between alert log file and tarce file ?
what is integrity constrains?
how to retrieve daily sal from emp table in oracle 10g
What is different bet native dynamic sql and Dbms_Sql?
Does a Before form trigger fire when the parameter form is suppressed ?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
List the various oracle database objects?
What is an Index ?
what is difference between DBMS and RDBMS?
What are advantages fo Stored Procedures?
what are stored procedures?