How to add data using a view?

Perhaps I do not fully understand what a presentation is.

  • add data to where? Views are usually used for sampling, not for adding. Although you can write a trigger on the view that will add something to the table, but it would be logical that such a presentation would contain all the required fields of the table - Mike
  • There is a task: Create a view that contains information about employees and add a new employee with it. - Andrey Petrov
  • well then I would suggest all the same to choose not only fname but also other fields, at least those fields that you are going to fill in when inserting, and also the primary key of the table. - Mike
  • 2
    First, the presentation must be updated. Not all views are such. Secondly, specifically with your (return the code in place) there is such a problem: when you add an employee with a date before 2014, he will be added to the table, but will not appear in this view. The date in his Talmud wrote about it well. - Alexander Petrov
  • This view was related to another assignment) Thanks I have already added with the help of the view, but if it's not difficult for you, tell me where you can read a good article about the view (about updated and not updated) - Andrey Petrov

0