Please frame question correctly ... Seems u r question is something like b

<<labele>>
declare
a=10
b=20,
begin
some statements
declare
a=30
c=40
end;
what is the A value in nested block?

Question Posted / shekharjchandra

1 Answers
4876 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

Please Help Members By Posting Answers For Below Questions

what is query cache in mysql? : Sql dba

1026

what is the difference between cluster and non cluster index? : Sql dba

1019

Is hadoop a nosql?

994

What is varray in pl sql?

1067

Can a table contain multiple primary key’s?

1092

Why do we use cursors?

984

How do I view a view in sql?

943

How can you load microsoft excel data into oracle? : aql loader

1170

What are the types of records?

988

What is cursor and its types?

1060

what is top in tsql? : Transact sql

1113

How can I see all tables in sql?

1063

How to check if a column is nullable before setting to nullable?

1116

Does oracle roll back the transaction on an error?

1006

Can you skip header records while loading? : aql loader

1047