Interested to Buy Any Domain ? << Click Here >> for more details...
How packaged procedures and functions are called from the
following?
- 2 Answers
- 6394 Views
- I also Faced
- E-Mail Answers
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 the difference between Union and Union all. Which is faster.
I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body
Why do we use %rowtype & %type in plsql?
What is group by in sql?
How much does sql certification cost?
What is identity column in sql server?
What does select top 1 do in sql?
What is a nested table in word?
what is query cache in mysql? : Sql dba
What is clustered index sql?
which tcp/ip port does sql server run on? : Sql dba
What is spool?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
