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
- 16289 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is a relationship and what are they?
Does oracle roll back the transaction on an error?
Explain the working of primary key?
Is foreign key mandatory?
What is the advantage of index in sql?
What is dynamic query?
What is difference between rank () row_number () and dense_rank () in sql?
What is online transaction processing (oltp)?
Is a view faster than a stored procedure?
How to create your own reports in sql developer?
What program will open a mdb file?
What is query syntax?
What is the difference between mdf and ndf files?
What is insert command in sql?
