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
- 19921 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / parivesh sinha
declare
x number:=1;
x1 number:=2;
y number:=3;
y1 number:=4;
begin
x := y1- y;
dbms_output.put_line (x);
x1 := y1+1 - y;
dbms_output.put_line (x1);
y := x +x1;
dbms_output.put_line (y);
y1 := x1+1 +x;
dbms_output.put_line (y1);
end;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the file extension for sql database?
When you have to use a default "rollback to" savepoint of plvlog?
How do I view a table in sql?
What is sql*loader and what is it used for? : aql loader
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Why sql query is slow?
How do I audit the sql sent to the server?
Is sql procedural language?
Are stored procedures faster than queries?
What is lookup table in sql?
Explain foreign key in sql?
List and explain the different types of join clauses supported in ansi-standard sql?
What is pl sql quora?
Explain what is sql*plus?
what are the join types in tsql? : Transact sql
