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 scripts in data base?
Give the constructs of a package, function or a procedure.
what is the syntax of CREATE command?
How to assign values to variables?
how to get the no employee in each department including the dept which has 0 employee
how can we write trigger in trigger???????? can we write one trigger on two table???
how to select second mauximum value in a given table under salary column
What are virtual columns?
Can we protect our pl/sql source code?
what are the different types of cursors? explain?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
What are internal user account in oracle?