How packaged procedures and functions are called from the
following?
Answers were Sorted based on User's Feedback
Answer / rajesh
The package procedure and function are called by using
package name.function/procedure name....
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What is procedure and function?
what are date and time data types in mysql? : Sql dba
What does count (*) mean?
Please let me know if UNION ALL and Natural Join does the same operation and are same...
What are field types?
What does := mean in pl sql?
What is the most important ddl statements in sql are?
What are character functions in sql?
How to find the count of letter "L" in HELLO
difference between cursor and procedure in a package
What is the syntax and use of the coalesce function?
explain the difference between delete , truncate and drop commands? : Sql dba