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 to do if the binary spfile is wrong for the default instance?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
Give the different types of rollback segments.
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is tns entry?
How to define an oracle cursor variable?
How do I reset a sequence in oracle?
How to establish administrator authentication to the server?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
when i run my query on yesterday it is fast but today it is slow why?
what is the syntax of DELETE command?