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
- 19389 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / sheshadri
String x="1,2";
String y="3,4";
x=(y+"$"+(y=x)).split("[$]")[0];
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
When should I use nosql database?
Do we need to rebuild index after truncate?
Show code of a cursor for loop.
State some properties of relational databases?
What is self-join and what is the requirement of self-join?
What are the different set operators available in sql?
What is the usage of distinct keyword?
What is clause?
What is the usage of the distinct keyword?
how to drop an existing index in mysql? : Sql dba
What is data profiling in sql?
Explain lock escalation? : Transact sql
What are the events on which a database trigger can be based?
What sql database should I use?
