Can a view be updated/inserted/deleted? If Yes under what conditions ?

Can a view be updated/inserted/deleted? If Yes under what conditions ?
by

1 Answer

Answer :

A View can be updated/deleted/inserted if it has only one base table if
the view is based on columns from one or more tables then insert,
update and delete is not possible.
by

Related questions

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Last Answer : It won't, Because SYSDATE format contains time attached with it.

Soft Pages breaks __________: a) are induced by the user b) are inserted by word automatically at the end of the page c) can be deleted d) are the one to show end of paragraph e) None of The Above

Description : Soft Pages breaks __________: a) are induced by the user b) are inserted by word automatically at the end of the page c) can be deleted d) are the one to show end of paragraph e) None of The Above

Last Answer : b) are inserted by word automatically at the end of the page

The seven elements A, B, C, D, E, F and G are pushed onto a stack in reverse order, i.e., starting from G. The stack is popped five times and each element is inserted into a queue. Two elements are deleted from the queue and pushed back onto the stack. Now, one element is popped from the stack. The popped item is ................... (1) A (2) B (3) F (4) G

Description : The seven elements A, B, C, D, E, F and G are pushed onto a stack in reverse order, i.e., starting from G. The stack is popped five times and each element is inserted into a queue. Two elements are deleted from the queue and pushed ... The popped item is ................... (1) A (2) B (3) F (4) G

Last Answer : Answer: 2

On the computer Pen drive When inserted Computer Slow Become Yes , of course From Of salvation Way What ?

Description : My On the computer Pen drive Once inserted And Work No , now What? Shall I ?

Last Answer : You Yours The pen drive Format By Computer Restart Please. Hope I do That's right Become Will go

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Description : If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Last Answer : For some objects, such as assignments, more than one update per day is maintained by creating a physical record for each update. Such objects include an effective sequence number in each physical record to show the order in which updates made to an object on a single day were applied.

Can you make a Datafile auto extendible? If yes how?

Description : Can you make a Datafile auto extendible? If yes how?

Last Answer : YES. A Datafile can be auto extendible. Here's how to enable auto extend on a Datafile: SQL>alter database datafile '/u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF' autoextend on; ... 'alter database datafile '|| file_name|| ' '|| ' autoextend on;' from dba_data_files; SQL>@runts

Is the following piece of code valid? >>> a=(1,2,3,4) >>> del a a) No because tuple is immutable b) Yes, first element in the tuple is deleted c) Yes, the entire tuple is deleted

Description : Is the following piece of code valid? >>> a=(1,2,3,4) >>> del a a) No because tuple is immutable b) Yes, first element in the tuple is deleted c) Yes, the entire tuple is deleted

Last Answer : c) Yes, the entire tuple is deleted

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?

Last Answer : SHOW ERRORS

What view would you use to determine free space in a tablespace?

Description : What view would you use to determine free space in a tablespae?

Last Answer : DBA_FREE_SPACE

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

If a View on a single base table is manipulated will the changes be reflected on the base table ?

Description : If a View on a single base table is manipulated will the changes be reflected on the base table ?

Last Answer : If changes are made to the tables which are base tables of a view will the changes be reference on the view.

What are the advantages of VIEW ?

Description : What are the advantages of VIEW ?

Last Answer : To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

What is a view ?

Description : What is a view ?

Last Answer : A view is stored procedure based on one or more tables, it’s a virtual table.

What is a canvas-view?

Description : What is a canvas-view?

Last Answer : A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they ... assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.

What is the content view and stacked view?

Description : What is the content view and stacked view?

Last Answer : A content view is the "Base" view that occupies the entire content pane of the window in which it is displayed. A stacked view differs from a content canvas view in that it is not the base view for the window to which it is assigned

Do a view contain data?

Description : Do a view contain data?

Last Answer : Views do not contain or store data.

Can you have more than one content canvas view attached with a window?

Description : Can you have more than one content canvas view attached with a window?

Last Answer : Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

How does one get the view definition of fixed views/tables?

Description : How does one get the view definition of fixed views/tables?

Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';

Can a view based on another view?

Description : Can a view based on another view?

Last Answer : Yes.

What is a View ?

Description : What is a View ?

Last Answer : A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

Do View contain Data ?

Description : Do View contain Data ?

Last Answer : Views do not contain or store data.

Can a View based on another View ?

Description : Can a View based on another View ?

Last Answer : Yes.

What is an Oracle view?

Description : What is an Oracle view?

Last Answer : A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

What is VDL (View Definition Language)?

Description : What is VDL (View Definition Language)?

Last Answer : It specifies user views and their mappings to the conceptual schema.

What is a view? How it is related to data independence?

Description : What is a view? How it is related to data independence?

Last Answer : A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other ... users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

What is the difference between a view and a materialized view?

Description : What is the difference between a view and a materialized view?

Last Answer : A view is a select that is executed each time an user accesses to it. A materialized view stores the result of this query in memory for faster access purposes.

How can you view all the current users connected in your database in this moment?

Description : How can you view all the current users connected in your database in this moment?

Last Answer : SELECT COUNT(*),USERNAME FROM V$SESSION GROUP BY USERNAME;

How can you view all the users account in the database?

Description : How can you view all the users account in the database?

Last Answer : SELECT USERNAME FROM DBA_USERS

In which view can you find information about every view and table of oracle dictionary

Description : In which view can you find information about every view and table of oracle dictionary

Last Answer : DICT or DICTIONARY

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

Coal gas is obtained by mixing coal and gas at ambient conditions.  A. Yes  B. No

Description : Coal gas is obtained by mixing coal and gas at ambient conditions.  A. Yes  B. No

Last Answer : Answer: B

How would you determine the time zone under which a database was operating?

Description : How would you determine the time zone under which a database was operating?

Last Answer : select DBTIMEZONE from dual;

If a break order is set on a column would it affect columns which are under the column?

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

1. Who is the author of the book ‘Glimpses of World History’ ? 2. Which are the glands of the body which pour their seretions directly into the blood stream? 3. The Fundamental Right to Property has been deleted by the which Amendment Act? 4. Which state is with the largest area under waste land? 5. On which basis Montague-Chelmsford Report formed?

Description : 1. Who is the author of the book Glimpses of World History' ? 2. Which are the glands of the body which pour their seretions directly into the blood stream? 3. The Fundamental ... development of hydroelectricity the pioneering state? 20. Which dynasty did rule over Magadha after Nanda dynasty?

Last Answer : Answer : 1. Jawaharlal Nehru 2. Endocrine glands 3. 44th 4. Jammu and Kashmir 5. The Government of India Act, 1919 6. Iron 7. Kanyakumari 8. Fiscal policy 9. Saddle Peak 10. Gandhiji 11. ... 14. Gandhi Sagar 15. Pandya 16. Bharatnatyam dancer 17. Gram 18. Mitochondrium 19. Karnataka 20. Maurya

What are some things that feel outdated and need to be updated to 2022?

Description : What are some things that feel outdated and need to be updated to 2022?

Last Answer : Probably starting wars over a grudge

Is there a website where you can search for a movie and it accurately shows where it’s streaming and is constantly updated?

Description : Is there a website where you can search for a movie and it accurately shows where it’s streaming and is constantly updated?

Last Answer : Justwatch.com ! I fuckin LOVE that site. I use it like once a day

How do you get the link posted and not the updated page?

Description : How do you get the link posted and not the updated page?

Last Answer : You don't have control over it. The URL that you referred to today is pointing to a page that is housed at a server somewhere else. It isn't under your control or Fluther's - it is under the control of ... a month or a year ago. Summary: it isn't under your control. You get the page they send you.

How does the Chrome browser get updated?

Description : How does the Chrome browser get updated?

Last Answer : My son works on Chrome mobile. If now one else knows, I can e-mail him the question.

What is a updated free YouTube video of the documentary waiting for superman, inequality for all, and ivory tower?

Description : What is a updated free YouTube video of the documentary waiting for superman, inequality for all, and ivory tower?

Last Answer : Ok I’m willing to pay for a documentary on education made this year. Even a good book. Suggest one or more non-fiction books and video. Please

Where can I get updated drivers for my internet connection?

Description : Where can I get updated drivers for my internet connection?

Last Answer : I'm going to guess that the Comcast WiFi has only current encryption methods, and not the older kind, and that your laptop might only be able to handle the older kind, it's possible a driver could ... hib on the comcast, and set it to the older style encryption then connect your old laptop to that.

Has anyone updated to windows 10 yet?

Description : Has anyone updated to windows 10 yet?

Last Answer : No,but will get it when my W7 net book dies.

I just updated to ios 7. How do I get rid of "Storage almost full" message?

Description : I just updated to ios 7. How do I get rid of "Storage almost full" message?

Last Answer : Do you have lots of songs on your device? That’s what caused the message for me. They were automatically installed on my iPhone from a previous backup.

How important is it to keep apps updated on a smartphone?

Description : How important is it to keep apps updated on a smartphone?

Last Answer : answer:@NuclearWessels Great screen name. Welcome to Fluther. Most updates are aimed at patching potential security threats, so if you do anything that you wouldn't want to share with hackers, or tether anything ... want a virus in, keep apps current or ditch them if they aren't worth the trouble.

How does a computer know that it needs to be updated when it's not even connected to the internet?

Description : How does a computer know that it needs to be updated when it's not even connected to the internet?

Last Answer : answer:It is longing for a “internet connection”. I am a nice person.

Trouble with Itunes since I updated. Any suggestions?

Description : Trouble with Itunes since I updated. Any suggestions?

Last Answer : Are you on OS X or Windows? If you use OS X I can probably help. Not so much with Windows.

Who would you suggest to star in an updated "Think Different" video?

Description : Who would you suggest to star in an updated "Think Different" video?

Last Answer : Oprah (who I never used to like, until I actually LISTENED to her speak).