Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 13 Answers
- 22923 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / shailesh j
If column contains data then we can only modify size of
column without changing its data type. But if the column is
empty then we can modify its size as well data type.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is trigger in flip flop?
How do I create an index in word?
Can a composite key be null?
Which data type is a composite type?
How can you create an empty table from an existing table?
What is the need of a partition key?
Can you have more than one trigger on a table?
The select into statement is most often used to create backup copies of tables or for archiving records?
Is left join inner or outer by default?
How many triggers can be applied on a table?
What is mdf ldf and ndf?
Can triggers stop a dml statement from executing on a table?
how to drop an existing view in mysql? : Sql dba
Can we insert in sql function?
What is data definition language?
