Last answered:

18 Mar 2024

Posted on:

17 Mar 2024


How A view is different from Routines ?

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

1 answers ( 0 marked as helpful)
Posted on:

18 Mar 2024


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.

Submit an answer