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

Explain some predefined exceptions.

0 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

Can I create table without primary key?

0 Answers  

---

What are stored procedures in mysql?

0 Answers  

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

what is definer rights invoke rights?

1 Answers  

---

What are conditional predicates?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---