How A view is different from Routines ?

Question

Hello Team

As view and routines reduces manually burden of typing code again and again, what will be difference between View and Routines ?

Thanks in advance

Answer 1

Hi Vijayanandh!
Thanks for reaching out.

Views are like saved queries that look and act like tables, showing data from one or more tables based on a set SQL statement.

Routines, which include stored procedures and functions, are blocks of code that perform specific tasks and can be executed with a call.

While views simplify data access, routines automate and encapsulate complex operations or calculations.

Hope this helps.
Best,
Tsvetelin

Submit an answer