what is difference between stored procedures and application procedures,stored

what is difference between stored procedures and
application procedures,stored function and application
function?

Question Posted / swapna

1 Answers
11460 Views
I also Faced
E-Mail Answers

what is difference between stored procedures and application procedures,stored function and appli..

Answer / swapna

stored procedures are subprogrammes stored in the database
and can be called & execute multiple times where in an
application procedure is the one being used for a
particular application same is the way for function.

Is This Answer Correct ?

11 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

can sql servers linked to other servers like oracle? : Sql dba

0 Answers

With out using count() function. How to the find total number of rows in a table?

6 Answers

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers Societe Generale,

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers Wipro,

What are the different datatypes available in PL/SQL?

0 Answers

How many types of database triggers can be specified on a table ? What are they ?

2 Answers

What is a memo field?

0 Answers

How does left join work in sql?

0 Answers

how many columns can be used for creating index? : Sql dba

0 Answers

What are the types of records?