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 19474Create 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 22060What 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 18140Post New Oracle SQL PLSQL Interview Questions
What are the main features of ms excel?
wats the difference between RS latch using NAND n NOR gate? which is to be preffered?
What is the use of limit() function in mongodb?
What's taking up space on my pc?
Is port 8000 a tcp or udp?
What are distinct operators in impala?
What is fopl stand for and explain its role in artificial intelligence?
Some Realtime Objects on Bdc.
Why unix is secure than windows?
Who is debtor purchaser
What is the new version of qtp which is recently released in the market?
How do I change the graph settings in excel?
What are the annotations used in hibernate?
How would you convince someone to follow your idea?
How the warning lamp of a charging-system is activated ?