Can we modify data in data base table using view?

Answer Posted / m damodar sai

DataBase View : this view can be built over many tables
Data can be modified if the view is built over a single table.

Projection View : this view must be built over a single table
Data can be modified through this view.

Maintenance view : Data can be modified using this view , but generally these prefered when data distributed to several tables forms a logical unit for the user.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you find the field/data underlying a transaction?

605


How many types of tables exists and what are they in data dictionary?

938


What are uses of foreign key?

572


What are the three hierarchical levels of data types and objects?

581


How we format the data before writing a statement in the report?

512






Does the table can have multiple foreign keys?

597


What are null values?

604


What does the insert statement in extract datasets do?

628


SM35 transaction, How to automate BDC ?

614


Explain the client concept of sap.

588


What are the different types of luws?

664


How did you transfer legacy data in the mid of the financial year (us) to the sap system? : sap abap hr

541


On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?

598


Update function modules are classified as either v1 or v2. Which type of update is performed first and in what mode (asynchronously, synchronously or locally) can each type be processed in?

571


What is static attribute

1090