Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

What has stored procedures in sql?

0 Answers  

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

Which is better trigger or stored procedure?

0 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

What are tables and fields in the database?

0 Answers  

Explain how can you save or place your msg in a table?

0 Answers  

Why is sql important?

0 Answers  

What are different joins used in sql?

0 Answers  

How do I sort a table in sql?

0 Answers  

What is difference between select statement and cursor

3 Answers   JDA,

For more SQL PLSQL Interview Questions Click Here
Categories