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
- 20308 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 escape special characters in sql statements? : Sql dba
How do I audit the sql sent to the server?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can we use threading in pl/sql?
what does the t-sql command ident_current does? : Transact sql
How long does it take to learn pl sql?
What does pl sql stand for?
What is a constraint? Tell me about its various levels.
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is trigger in sql? Explain
What is pl sql commands?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is triggering circuit?
what are the types of subquery? : Sql dba
What is compilation error in pl sql?
