What is difference between stored procedures and application procedures?
- 1 Answers
- 1110 Views
- I also Faced
- E-Mail Answers
Answer Posted / Aditya Tiwari
Stored procedures are PL/SQL programs that reside within the database, while application procedures (functions and subprograms) exist within the application. Stored procedures can be invoked by multiple applications, making them more efficient as they reduce network traffic and improve performance. On the other hand, application procedures provide a way to modularize complex logic within an individual application.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I remove duplicates in two columns?
what are aggregate and scalar functions? : Sql dba
what is collation? : Sql dba
Is primary key clustered index?
If a cursor is open, how can we find in a pl/sql block?
Is inner join faster than left join?
Does group by remove duplicates?
what is bcp? When does it used? : Sql dba
What is the current version of postgresql?
Can we use distinct and group by together?
Do we need to rebuild index after truncate?
Is primary key always clustered index?
what is schema? : Sql dba
what are the advantages of sql ? : Sql dba
how to start mysql server? : Sql dba
