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 16112Create 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 18453What 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 15710Post New Oracle SQL PLSQL Interview Questions
Do you enjoy doing independent research?
Can a foreign key have a different name?
Is method and function same?
What is the difference between a site and a web?
What is black box testing? What are the different black box testing techniques?
132/6.6ππ πππππππππππ πππππππ πππ πππ πππππ πππ πππππππππ. πΈ'ππ πππππππ πππππππππππ ππ 6.6ππ/415π πππ πΈ πππππππ πππππππ ππ ππππ πππππ πππ ππ ππ 13/6.ππ πππππππππππ?? πΈπ π½π.. ππππ π ππ’??
Why coalesce is used in sql?
How are the diagrams divided?
what are the main prerequisite needed starting learning android?
Which commands you use to lock the database in mongodb?
What are the three parts of XSL?
Will water damage concrete?
How automation process is carried out?
What are the function keys for microsoft word?
What is the difference between c and python?