what diffrence between function and procedure?

Answer Posted / manu sankar

Functions can be called inside a sql but procedures cannot

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens to the current transaction if the session is ended?

530


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1624


How to sort output in descending order in oracle?

582


How to convert characters to numbers in oracle?

596


Explain the use of rows option in exp command.

588






What is an oracle recycle bin?

553


Write a trigger example in oracle?

577


How to download oracle database 10g xe?

602


how do u setup a replication site?

1504


What is tns service name?

626


What is flashback in Oracle?

584


What happens if you use a wrong connect identifier?

505


Explain drop constraint oracle?

595


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1809


Explain the blob datatype?

622