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

yeah completely agree with u(the above person).The answer
was supposed to be in a single statement and everybody
wrote an history 4 it....hehe
no offence meant

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is pl sql different from sql?

536


Cite the differences between execution of triggers and stored procedures?

607


Explain the the update statement in sql?

562


how can we find the number of rows in a table using mysql? : Sql dba

575


Differentiate between sga and pga.

663






List the various privileges that a user can grant to another user?

570


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

589


how to do backup entire database? : Transact sql

606


How to get each name only once from an employee table?

602


What is the maximum rows in csv?

482


what is csv? : Sql dba

567


I need a function for a train ticket reservation please answer it thanks in advance

559


What are string functions in sql?

669


What is cross join sql?

492


Can a composite key be null?

522