We can use a function in the select query, but Procedure we can't use

What is Difference between StoredProcedure and function?

Question Posted / prabhu karanam

3 Answers
7475 Views
I also Faced
E-Mail Answers

We can use a function in the select query, but Procedure we
can't use in select query. But the function created with out
parameter, we can't use in select statement. Only in
parameter, we can use.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the type of locks ? : Sql dba

945

Why we use joins in sql?

965

what is the difference between join and union? : Sql dba

1090

what are the performance and scalability characteristics of mysql? : Sql dba

986

Difference between truncate, delete and drop commands?

1065

What is sql query limit?

960

What is the difference between alter trigger and drop trigger statements?

1092

Advantages and disadvantages of stored procedure?

1103

What is int identity in sql?

1115

How do I add a database to sql?

1110

What is the use of count (*) in sql?

1031

How do I view an execution plan in sql?

968

What are pl/sql packages?

1085

what are myisam tables? : Sql dba

1016

What is record type in pl sql?

977