Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

<<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 / rameshrevella


<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; wh..

Answer / 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

More SQL PLSQL Interview Questions

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

what are the advantages of using stored procedures? : Sql dba

0 Answers  

what is sql server agent? : Sql dba

0 Answers  

..........refers to the disk mirroring

2 Answers   iFlex,

wtite down triggr not any entry on Sunday

2 Answers   NIT,




Why query optimization is needed?

0 Answers  

What is sap sql?

0 Answers  

What is embedded sql in db2?

0 Answers  

What is a join query?

0 Answers  

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

What is PL/SQL table ?

6 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories