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
- 19410 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 are the advantages of stored procedure?
How do I enable sql encryption?
Why we use joins in sql?
What is sql entity?
What is a behavioral trigger?
What is dynamic query?
Why should I use postgresql?
what is a view? : Sql dba
How can you load multi line records? : aql loader
What is trigger in sql? Explain
What is the size of partition table?
Can we create index on primary key?
what are dynamic queries in t-sql? : Transact sql
What is sql integrity?
how to present a past time in hours, minutes and seconds? : Sql dba
