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 / 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
What is range partitioning?
How do you use a while loop in pl sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
how to use in conditions? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
What is dml and ddl?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Is hadoop a nosql?
What is a primary key example?
What are sql data types?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What happens when a trigger is associated to a view?
How to get unique records from a table?
What are the two types of cursors in pl sql?
Why having clause is used in sql?