How packaged procedures and functions are called from the
following?
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 the process of copying data from table a to table b?
what is the difference between nested subquery and correlated subquery?
What do you mean by field in sql?
Is drop table faster than truncate?
What are records give examples?
What is user defined functions?
Does user triggers have entry for trigger with compilation errors?
Is progress software supports to ( pl/sql )?
How to check if a column is nullable before setting to nullable?
What is rename command in sql?
How do I add a primary key to a table?
How is pl sql different from sql?
How do I trace sql profiler?
What is a procedure in pl sql?
What is difference between nchar and nvarchar?