<<labele>>
declare
a=10
b=20,
begin
some statements
declare
a=30
c=40
end;
what is the A value in nested block?
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 |
if i perform any operation on views such as insert, delete etc will my base table get affected?????
What is a pdo connection?
What is normalization and types of normalization?
22 Answers Etisbew, F-TEC, Microsoft, TechProcess,
How many types of cursors supported in pl/sql?
What is a schema sql?
What is an exception in PL/SQL? What are the two types of exceptions?
Does group by remove duplicates?
What company owns postgresql?
what is meant by databases
What are three advantages to using sql?
How do I create a memory optimized filegroup?
what is the purpose of update command in oracle?