Interested to Buy Any Domain ? << Click Here >> for more details...
How packaged procedures and functions are called from the
following?
- 2 Answers
- 6276 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 duration in sql profiler trace?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is rename command in sql?
Why partition by is used in sql?
Compare sql & pl/sql
What are the query optimization techniques?
what are string data types? : Sql dba
What is crud sql?
How to rename a table?
What is meant by temporal data?
What is auto increment?
How do I debug a stored procedure?
What does stand for in sql?
how is myisam table stored? : Sql dba
Are subqueries faster than joins?
