Interested to Buy Any Domain ? << Click Here >> for more details...
<<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
- 4785 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
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
what's the difference between a primary key and a unique key? : Sql dba
What is dense_rank in sql?
Can %notfound return null after a fetch?
how to shut down the server with 'mysqladmin'? : Sql dba
Are stored procedures faster than dynamic sql?
Can two tables have same primary key?
How to select all records from the table?
How do you explain an index number?
what is the syntax used for partition in tsql? : Transact sql
What is data modelling in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Is mariadb a nosql database?
How to take user input in pl sql?
how to drop an existing index in mysql? : Sql dba
