Generally, how would you describe the way you influence others?

geekp

 Profile Answers by geekp Questions by geekp

• Dec 16th, 2008

As long as you can identify the pros and cons, ensuring more pros of your ideas and can then quantify your reasons. Then other party will be more open to your ideas

nalinbit

 Profile Answers by nalinbit Questions by nalinbit

• Dec 6th, 2008

To Influence others means you need to convince others with your idea. This idea can be genuine or forced one (which you yourself not agree to, generally posed by management). In both the cases you ...

Answer Question  Select Best Answer

Does View occupy memory? If we delete the base table of existing view, What happens?

Read Best Answer

Editorial / Best Answer

Mad Hatter  

 Profile Answers by Mad Hatter Questions by Mad Hatter

• Member Since Nov-2008 | Nov 4th, 2008

---

View does not occupy memory, but Oracle keeps view code in its dictionary (you can check in user_views, for example)
If you delete the base table, the view becomes INVALID.
In order to make it valid again, you have to ether build the deleted table again, or create anotehr view with the same name and structure as deleted table, or create synonym with the same name as deleted table, which will point to the table with the same structure.

pkshve

 Profile Answers by pkshve Questions by pkshve

• Sep 12th, 2010

Views are database objects - they are just SQL code stored in database which will be executed every single time the view is called. Database will check the existance of columns and tables in the base ...

manimehra905

 Profile Answers by manimehra905 Questions by manimehra905

• May 18th, 2010

View does not occupy memory as it only provides a way for watching multiple views of an object: Table. Moreover, it is a virtual table which does not take space.It provides DATA HIDING.For e.g. i...

Improve Answer

Read Best Answer

Editorial / Best Answer

rishipahuja  

 Profile Answers by rishipahuja Questions by rishipahuja

• Member Since Aug-2006 | Aug 6th, 2006

---

rowid has a physical significance i.e you can read a row if you know rowid. It is complete physical address of a row.

While rownum is temporary serial number allocated to each returned row during query execution.

vinay

• Sep 20th, 2015

It it will be re-assigned to a different row when inserted by Oracle.

Arif

• Jul 3rd, 2015

I have one doubt like you said that rowid is automatically created when we add a row(record) then what happens to rowid
when we delete that record?

Improve Answer