How packaged procedures and functions are called from the
following?
- 2 Answers
- 5756 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
Explain correlated query work?
Is json a nosql?
Can you join a table to itself?
is mysql query is case sensitive? : Sql dba
What is orm in sql?
Is hadoop a nosql?
Which software is used for pl sql programming?
What is the difference between left join and right join?
Enlist the characteristics of pl/sql?
What do we need to check in database testing?
What do you mean by query optimization?
What will you get by the cursor attribute sql%rowcount?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is loop in pl sql?
Define tables and fields in a database
