What is difference between Procedures and Functions ?

Answer Posted / shasi

Hi,

The main think is function canbe used in sql select
statement but procedure wer can't use.procedure redurn more
then value(max:1024)funcion must return 1 value

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to convert character strings to numeric values? : Sql dba

569


How do you respond to dementia behavior?

526


Is oracel sql developer written in java?

644


Does mysql_real_escape_string prevent sql injection?

535


What is pl sql and why it is used for?

565






Can there be more than one function with a similar name in a pl/sql block?

539


what are rollup and cube in t-sql? : Transact sql

657


What does select * from mean in sql?

1981


What is the difference between syntax error and runtime error?

609


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

548


What is the difference between delete and truncate statement in sql?

486


How many clustered indexes can you have?

529


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

525


What is a unique key and primary key and foreign key?

565


What is the best free sql database?

558