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.

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

How does sql profiler work?

0 Answers  

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

Can we insert data into view?

0 Answers  

What does rownum mean in sql?

0 Answers  

How does join work in sql?

0 Answers  

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

What is the use of & in pl sql?

0 Answers  

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

Name the operator which is used in the query for pattern matching?

0 Answers  

What is sql keyword?

0 Answers  

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers