Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate b/w Modify and Update commands giving example.
- 1 Answers
- 3823 Views
- I also Faced
- E-Mail Answers
Answer Posted / ananth kumar
1.update comand is to make changes to the record in the
table
2.modify command is used to add,modify,drop a column in a
table
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Suppose we have a table name EMP as below. We want to perform a operation in which, I want to change name ‘SMITH’ from as ‘SMITH JAIN’. Also I want to change the name of the column from ENAME to E_NAME. EMPNO ENAME JOB MGR HIREDATE SAL 7369 SMITH Coder 7902 17-DEC-80 800 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 7521 WARD SALESMAN 7698 22-FEB-81 1250
What is meant by 'bit masking'?
Stimulate calculator using Switch-case-default statement for two numbers
Can you write a programmer for FACTORIAL using recursion?
Write a program in c to replace any vowel in a string with z?
How do you construct an increment statement or decrement statement in C?
What is action and transformation in spark?
define string ?
What is meant by inheritance?
What are header files why are they important?
Which driver is a pure java driver
How do I read the arrow keys? What about function keys?
What is a program flowchart and how does it help in writing a program?
How do you override a defined macro?
What is context in c?
