there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we hav

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?

Question Posted / smitha

12 Answers
20313 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values..

Answer / 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

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values..

Answer / santhi k

IN ORACLE...

SELECT DECODE(X,X,Y)X,DECODE(Y,Y,X)Y FROM TABLENAME;

Is This Answer Correct ?

0 Yes

6 No

Post New Answer

More SQL PLSQL Interview Questions

Can we call stored procedure in function?

0 Answers

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers Fidelity, IBM,

Is pl sql useful?

0 Answers

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers

What are tuples in sql?

0 Answers

What is data manipulation language?

0 Answers

Difference between SUBSTR and INSTR?

3 Answers

What is the basic difference between a sql and stored procedure ?

2 Answers L&T,

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers

What is the difference between sql/pl-sql/embeded sql?