Create 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.
Answer Posted / nzabin
SQL Error: ORA-01439: column to be modified must be empty to change datatype
01439. 00000 - "column to be modified must be empty to change datatype"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql and its types?
How delete all data from all tables in sql?
What is clustered and nonclustered index in sql?
How to look at the current sql*plus system settings?
Can a table contain multiple primary key’s?
How do I quit sql?
What is the command used to fetch the first 5 characters of a string?
How many scalar data types are supported in pl/sql?
Why select is used in sql?
Does oracle roll back the transaction on an error?
what is a database lock ? : Sql dba
how to include comments in sql statements? : Sql dba
Why primary key is required?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
How many sql are there?