Why do we need to use view? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Why do we need to use view?

23rd Mar 2016, 5:53 PM
Mohammed Alghazzawi
Mohammed Alghazzawi - avatar
2 Answers
+ 2
we use views because of simplicity suppose we have a select statement to join several tables and take many unions ,it would not be sensible to write whole code in single statement ,it will be harder to understand while if we use veiw every step would be clear and better understandable
14th Jul 2016, 7:54 PM
manish rawat
manish rawat - avatar
+ 1
create view is the best approach for extracting reports.
19th Mar 2016, 3:03 PM
Lloyd Mwaluku
Lloyd Mwaluku - avatar