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

I have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible

Question Posted / akshay

Answers were Sorted based on User's Feedback



I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / manoj

1.
alter table <table_name>
add column<col_name> <data_type>[not null];

2.
for inserting values

Depends: if u have data in another table than u can insert
by making small packege (using cursor)

OR :u can also sequence to insert

Is This Answer Correct ?    2 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / premraj

alter table table_name add c4 varchar2(30) default null

Is This Answer Correct ?    2 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / asraf

ALTER TABLE DUMMY1 ADD (C4 VARCHAR2(100) DEFAULT 0)

Is This Answer Correct ?    1 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / ravi singh

You can alter the table but u can not make the column as
null, and your insert statement will depends upon the
condition that u specified.

Is This Answer Correct ?    0 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / gayathri

Alter table tablename ADD(columnname (data_type) notnull)

Is This Answer Correct ?    0 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / ramprasad.s

hi


Alter Table <Table Name> ADD( <Column name> <data type>)

you can insert values by using <update> with reference

to the existing values of the other columns.
bye

sun_ramprasad@yahoo.com

Is This Answer Correct ?    0 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / jyothi

alter the table -> alter table <table name> <datatype>
after then u can insert values in that clounm bu using
UPDATE ...
update set column name= value where condition
condition ....where u want to update the value means which
row...

Is This Answer Correct ?    0 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / srinivas

alter table <table-name> add(<column-name> datatype
[constrains]);

Is This Answer Correct ?    0 Yes 0 No

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column..

Answer / shaik

u can alter the table. after that u can add the data
depending upon the criteria condition.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What can sql server reporting services do?

0 Answers  

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

what are the forced views

6 Answers   Hexaware, TCS,

What are sql queries used for?

0 Answers  

Explain 3 basic parts of a trigger.

0 Answers  




what is a view? : Sql dba

0 Answers  

What are the basic techniques of indexing?

0 Answers  

Is primary key clustered index?

0 Answers  

How bulk collect improves performance?

0 Answers  

what are the differences between char and nchar? : Sql dba

0 Answers  

What is auto increment?

0 Answers  

Does sap use sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories