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
- 20305 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 difference between sql and mysql?
explain mysql aggregate functions. : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
What are the advantages of sql?
How many functions are there in sql?
Does pl sql work in mysql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What are data types in pl sql?
What are all the different types of indexes?
how do you know the version of your mysql server? : Sql dba
What is the purpose of my sql?
What is left join example?
what is heap table? : Sql dba
How do sql databases work?
what is the syntax for using sql_variant_property? : Transact sql
