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?
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 sqlite format?
Is mariadb a nosql database?
How is data stored in sql?
Can we debug stored procedure?
Which table is left in join?
How can a function retun more than one value in oracle with proper example?
What is the best partition size for windows 10?
How can I delete duplicate rows?
Why do we use procedures?
What do you know by pl/sql cursors?
What is record in pl sql?
how to convert character strings to dates? : Sql dba
what is 'mysqlshow'? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
What is the command used to fetch first 5 characters of the string?