diff b/w function and procedure?

Answer Posted / muhammad sohail

function can be use in select clause and where clause
procedure can't

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to fetch common records from two tables? : Sql dba

633


Do prepared statements prevent sql injection?

531


Compare sql & pl/sql

612


Can we debug stored procedure?

525


What is a record in a database?

563






define join and explain different type of joins? : Sql dba

546


Does sql*plus have a pl/sql engine?

572


What does select count (*) mean in sql?

552


Explian rowid, rownum? What are the psoducolumns we have?

574


Which are the different case manipulation functions in sql?

539


Why is sql better than hql?

510


Does oracle roll back the transaction on an error?

537


What is on delete restrict?

542


Explain what is sql*plus?

670


What is clustered index in sql?

592