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

Why query optimization is needed?

0 Answers  

How do you bind variables in pl sql?

0 Answers  

We have a CURSOR then we need BULK COLLECT?

1 Answers  

What is sqlerrm?

0 Answers  

What is a primary key? Explain

0 Answers  

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

Show how functions and procedures are called in a pl/sql block.

0 Answers  

What is a procedure in pl sql?

0 Answers  

How many databases can sql express handle?

0 Answers  

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

For more SQL PLSQL Interview Questions Click Here
Categories