What is the Difference between Procedure and Function.Can we
call a Function in a DML?
Answer Posted / sharad kumar
1. Function must return a value like any other Programing
Language.
2.yes we can call function from a DML.Remember count(*),sum
etc...
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What does (*) mean in sql?
Why indexing is needed?
What is a composite primary key?
How to select 10 records from a table?
List and explain the different types of join clauses supported in ansi-standard sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is the difference between syntax error and runtime error?
What is the difference between view and stored procedure?
What are the different sql languages?
What information is needed to connect sql*plus an oracle server?
What is inner join in sql?
What is the main difference between sql and pl/sql?
List the ways to get the count of records in a table?
how to get help information from the server? : Sql dba