Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the procedure's, function's name from a package
if it is wrapped(both spec & body).
- 2 Answers
- 6685 Views
- I also Faced
- E-Mail Answers
Answer Posted / kart
for function
select package.funtname(parameter) from dual/table;
for procedure
exec packagename.procedurename(parameter);
u cant call the trigger
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are sql objects?
What is data definition language?
What is sql scripting?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
How can use stored procedures in sql?
how to include character strings in sql statements? : Sql dba
Name the operator which is used in the query for pattern matching?
Which data type is a composite type?
What are the types of views in sql?
Can we call dml statement in function?
What does select * from mean in sql?
Why is theta join required?
What are the types of join in sql?
What is an escape character in sql?
Can we use delete in merge statement?
