Interested to Buy Any Domain ? << Click Here >> for more details...
How packaged procedures and functions are called from the
following?
- 2 Answers
- 6171 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhavi
If A function returns only one value then u can call
that function from select statement like
select packagename.functionname(parameters) from dual,
But for procedure its not possible to call through select
statement u have to call through anonymous block.
declare
begin
packagename.procedurename(actual parameters);
end;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is rank () in sql?
Can you inner join the same table?
Which command is used to delete a package?
Write a unique difference between a function and a stored procedure.
What is database migration?
What are the types of records?
What is keys and its types?
Can you selectively load only those records that you need? : aql loader
What is hibernate and its relation to sql?
How do you respond to dementia behavior?
What is user defined functions?
how to get a list of columns in an existing table? : Sql dba
What is the difference between local variables and global variables?
Why do we use triggers?
how to do backup entire database? : Transact sql
