Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.


Please wait...

Technical Discussion :: Oracle PLSQL

8. What is a Stored Procedure? State its advantage.

Answer:

A stored procedure is a set of per-compiled SQL commands (query statements), which are stored in the server. It is faster then the loose SQL statements processed on client, as it is per-compiled. It can execute more then one SQL commands once as they are bundled in a single entity. We can use control statements within the stored procedure, which will allow us to repeat some SQL command. It can send return values depending upon the result. Stored procedures are used to reduce network traffic.

Asked In ::  Virtusa  

Post Your Answer Here:


Post Your Reply Here:

Alert me
q4i-reply-your-answer

Report Error

Please Login First Click Here