Answer Posted / vidya
Defining a Global variable is practically restricted,
Beco'z Renaming a Package is very nasty things, our
Database always available in Tree Structure. But Global
variable determined by whether you declare the variable
outside in the package (global)/ Procedure (global).
Declaring a variable in the body or the specification
determines if the variable is public (specification) or
private (body)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is parallel hint?
Can we call stored procedure in function?
Which is faster view or stored procedure?
How run sql*plus commands that are stored in a local file?
Can we create table in function?
How to make a copy values from one column to another in sql?
How can we optimize a sql query?
What is compute?
what are the differences among rownum, rank and dense_rank? : Sql dba
How do you create a db file?
What is the use of function in sql?
Can triggers stop a dml statement from executing on a table?
How many triggers can be applied to a table?
What is a common use of group by in sql?
Why do we use cursors?