<<labele>>
declare
a=10
b=20,
begin
some statements
declare
a=30
c=40
end;
what is the A value in nested block?
- 1 Answers
- 4432 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / shekharjchandra
Please frame question correctly ...
Seems u r question is something like below
<<label>>
DECLARE
a NUMBER := 10 ;
b NUMBER := 20;
BEGIN
-- Some statement
NULL ;
DECLARE
a NUMBER := 30 ;
c NUMBER := 40 ;
BEGIN
-- Some statement
NULL ;
END ;
END ;
/
Obviously the value of a in nested block will be 30 (Check this topic in Scope and visibility in Oracle documentation)
regards
J
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
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
What is the purpose of normalization?
what is heap table? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba
What is difference between sql and mysql?
How do you sort in sql?
Which are the different character-manipulation functions in sql?
What are hotfixes and patches?
what is the syntax used for partition in tsql? : Transact sql
what happens if null values are involved in expressions? : Sql dba
What is a design view?
What is embedded sql with example?
What is the difference between rename and alias?
What is the maximum size of sqlite database?
What is primary key and foreign key with example?
