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 |
how will u find statistics of a database objects?
What is the execution plan in sql?
What is a constraint?
Is primary key clustered or nonclustered?
What is mutating table?
What is relationship? How many types of relationship are there?
what is inline command?
Explain the difference between drop and truncate commands in sql?
what is the difference between where clause and having clause? : Sql dba
How delete a row in sql?
What is the difference between partitioning and sharding?
What is sql deadlock?