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.

How do I partition a table in sql?

0 Answers  

Why do we use partitions in sql?

0 Answers  

How do I filter in sql profiler?

0 Answers  

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

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 is a pl/sql block?

0 Answers  

What are stored procedures used for?

0 Answers  

describe transaction-safe table types in mysql : sql dba

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

How do you identify a primary key?

0 Answers  

What is sql dialect?

0 Answers  

What is sqlca in db2?

0 Answers