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

Answer / premraj

alter table table_name add c4 varchar2(30) default null

Answer / asraf

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

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.

Answer / gayathri

Alter table tablename ADD(columnname (data_type) notnull)

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

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...

Answer / srinivas

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

Answer / shaik

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

What is rank dense_rank and partition in sql?

0 Answers  

Why trigger is used in sql?

0 Answers  

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

How you improve the performance of sql*loader? : aql loader

0 Answers  

What is form and report?

0 Answers  

What is group by in sql?

0 Answers  

What is bulk collections?

2 Answers  

What is record variable?

0 Answers  

what is the difference between union and union all? : Sql dba

0 Answers  

How many levels can subqueries be nested in a FROM clause?

7 Answers  

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

What are types of exception?

0 Answers