Interested to Buy Any Domain ? << Click Here >> for more details...
How packaged procedures and functions are called from the
following?
- 2 Answers
- 6395 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
how to get a list of columns in an existing table? : Sql dba
What is primary key in db?
explain about mysql and its features. : Sql dba
define join and explain different type of joins? : Sql dba
How do I order by ascending in sql?
What is a constraint? Tell me about its various levels.
How to run sql commands in sql*plus?
Where is sql database stored?
What is set serveroutput on?
How to create an array in pl/sql?
Is it possible to sort a column using a column alias?
Which are sql * plus commands?
What is the starting oracle error number?
What are the different types of joins in sql?
How to revise and re-run the last sql command?
