It will work your query 100% will work Chers Taj

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.

Question Posted / tajuddin

13 Answers
22339 Views
Oracle, TCS, I also Faced
E-Mail Answers

Answer Posted / tajuddin

It will work your query 100% will work

Chers
Taj

Is This Answer Correct ?

9 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pl sql quora?

1126

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

955

What is the most common sql injection tool?

1027

How to read/write files from pl/sql?

1023

How to set up sql*plus output format in oracle?

1016

What are the two parts of design view?

1004

what are the advantages of sql ? : Sql dba

1042

what is self join and what is the requirement of self join? : Sql dba

1122

What will you get by the cursor attribute sql%found?

948

how to return query output in html format? : Sql dba

1059

How do I run a sql query in pgadmin 4?

945

How to move files from one directory to another in pl sql?

1172

What is rank function in sql?

1000

How many joins can you have in sql?

919

Explain raise_application_error.

1078