Interested to Buy Any Domain ? << Click Here >> for more details...
there are 2 variables called x and y ,x contains 1,2 and y
contains 3,4 we have to swap the values from x to y and y
to x with out using dummy variables and it can be done only
by using a single statement ? how?
- 12 Answers
- 19875 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / senthil kumar
declare
x number:= 1;
y number:= 3;
begin
x := x + y;
dbms_output.put_line (x); -- output 4;
y := x - y;
dbms_output.put_line (y); -- output 1;
x := x - y;
dbms_output.put_line (x); -- output 3;
end;
/
Now Y got 1 and x got 3 samae way of x = 2, y =4
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Are stored procedures compiled?
What is audit logout in sql profiler?
define join and explain different type of joins? : Sql dba
Why do we create views in sql?
What are the operators used in select statements?
What is the difference between the sql*loader and import utilities? : aql loader
what does myisamchk do? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
how to select unique records from a table? : Sql dba
What is acid property in a database?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to place comments in pl/sql?
What is union and union all keyword in sql and what are their differences?
