1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / krishna

Answer Posted / krishna

It wil not work

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster count (*) or count 1?

531

What are the two virtual tables available at the time of database trigger execution?

621

How to pipe multiline string to isql?

564

What is data modelling in sql?

512

What is primary key sql?

532




What is the use of <> sql?

544

What is difference between rank () row_number () and dense_rank () in sql?

560

Is mariadb nosql?

575

How to use sql*plus built-in timers?

566

What is difference between pls_integer and integer?

510

Can a commit statement be executed as part of a trigger?

596

How do I view tables in mysql?

532

what is user defined functions? : Sql dba

539

What are the possible values that can be stored in a boolean data field?

507

What is user in sql?

566