Interested to Buy Any Domain ? << Click Here >> for more details...
How packaged procedures and functions are called from the
following?
- 2 Answers
- 6283 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 are different methods to trace the pl/sql code?
What is break?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How do I get sql certification?
How many types of cursors supported in pl/sql?
What is normalization sql?
How do I remove sql developer from windows 10?
Why cross join is used?
what are the different index configurations a table can have? : Sql dba
What is the difference between sql and t sql?
What operating systems are supported by oracle sql developer?
What does sql stand for?
What is the purpose of a secondary key?
what is a database? : Sql dba
What is multiple columns?
