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

What are sql injection vulnerabilities?

985

---

What is prepared statement in sql?

1050

---

How subquery works in sql?

1070

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2555

---

Can we rename a column in the output of sql query?

995

---

what is a view? : Sql dba

1094

---

What are the types of dbms?

975

---

Mention what are different methods to trace the pl/sql code?

1208

---

What is the command used to fetch the first 5 characters of a string?

1209

---

What is the most restrictive isolation level? : Transact sql

1085

---

What is sql profiling in oracle?

1065

---

how to drop an existing table in mysql? : Sql dba

1044

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1223

---

how to include comments in sql statements? : Sql dba

958

---

Mention what does plv msg allows you to do?

1124

---