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 17762Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
13 20342What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
9 16895Post New Oracle SQL PLSQL Interview Questions
How do you format a spreadsheet?
Explain what helpers in codeigniter are and how you can load a helper file?
Tell me how would you freeze an object in ruby? Can you provide a simple example?
How do you know if I can install 64 bit windows?
What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary
What is the frequency of sampling for the materials of cement,Fine aggregate, Coarse aggregate .and refer which code
How can you maintain a relationship between different databases in access?
can any one send me tally professional version link
What is mysql data directory? How to determine the location of the data directory?
Who is supporting xaml? : xaml
What kind of supervision do you like?
what is the need for oobs
HOW TO CALCULATE S/C,O/C,E/F OF ACB.
What technical support do we get with Delphi?
Explain about Garbage Collector?