why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 9561 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / dhiraj
Packages are bunch of procedures and functions instead of
granting one by one procedure and function DBA can grant
packge to user.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
what is an alias command? : Sql dba
What is data modelling in sql?
how can we know the count/number of elements of an array? : Sql dba
How does sql developer connect to oracle database?
How do I use google cloud in sql?
How to set up sql*plus output format in oracle?
What is meaning of <> in sql?
What is over () in sql?
What's the procedure?
What is sql catalog?
Can a varchar be a primary key?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is transaction control language (tcl)?
What are expressions?
How does cross join work in sql?
