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
- 19968 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 commit? : Sql dba
Does a primary key have to be a number?
What does joining a thread mean?
How do I delete a trigger?
Why do we create stored procedures & functions in pl/sql and how are they different?
Define the select into statement.
what is 'mysqladmin' in mysql? : Sql dba
What is the use of %rowtype?
How to get help at the sql prompt?
Is sqlexception checked or unchecked?
Which join is like inner join?
How do you modify a table in sql?
Which sql statement is used to delete data from a database?
how many triggers are allowed in mysql table? : Sql dba
What is on delete restrict?
