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
- 4881 Views
- ITC Infotech, I also Faced
- E-Mail Answers
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 |
How do I access sql anywhere database?
what is a record in a database ? : Sql dba
What is nested table in pl sql?
Can a commit statement be executed as part of a trigger?
how would you enter characters as hex numbers? : Sql dba
Explain normalization and what are the advantages of it?
How do I delete a trigger?
How sql query is executed?
How do you optimize a stored procedure in sql?
Can you skip header records while loading? : aql loader
How many levels can subqueries be nested in a FROM clause?
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
