<<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
- 4328 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
what is online transaction processing (oltp)? : Sql dba
Can we insert in view in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Explain correlated query work?
What does bitemporal mean?
Does pdo prevent sql injection?
what is collation? : Sql dba
Can we insert data into materialized view?
Is sql developer case sensitive?
Can we create view in stored procedure?
What is mutating trigger?
what does the t-sql command ident_current does? : Transact sql
What is the requirement of self-join?
What found sql?
How do I remove sql plus from windows 10?
