Interested to Buy Any Domain ? << Click Here >> for more details...
A VIEWS takes memory in the database.
If yes, how can u proove it?
is there any way to display the size of views?
- 1 Answers
- 5264 Views
- IBM, I also Faced
- E-Mail Answers
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 |
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
how to retrieve data from different tables ,place this data in different excel worksheets.
What is Trigger in Oracle?
What happens to the current transaction if a ddl statement is executed?
How to view the data files in the current database?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Define 'view' advantage ?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
What is the usage of save points in oracle database?
What is cluster Key ?
What is the difference between I and G in Oracle?
Oracle General 
