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 16029Create 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 18365What 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 15634Post New Oracle SQL PLSQL Interview Questions
What do you understand by copy constructor in java?
How to generate all permutations of a list in python?
What is the use of ioc?
How to select a transformer group to connect a 0,433 KV generation with 33 KV grid in bi directional flow of current
what is clean sweep?
How to enable cURL in PHP?
How do managerial economies affect the country?
why chock were used in old tubelights but are not newest tubelights?
Explain the flow of creating a cube? : sql server analysis services, ssas
What are the benefits of ioc in spring?
What is HibernateTemplate class?
What are the difference between python and java?
How vugen create a vuser script?
What is icai?
When we are calculating the heat load sheets,why we are not considering the heat developed from the blood in the human body.Also both men & women can't acess aircondition in same way..women feel too cool even at 22 degree,while men can overcome that.