Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How do I view a sql trace file?

0 Answers  

What is the difference between SQL and PLSQL

7 Answers   IBM,

What does stand for in sql?

0 Answers  

What is pls integer?

0 Answers  

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

What are the blocks in stored procedure?

6 Answers   Microsoft,

Explain foreign key in sql?

0 Answers  

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

What is scalar data type in pl sql?

0 Answers  

Can you do multiple joins in sql?

0 Answers  

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

in a package one procedure is wrong package shows valid or not

4 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories