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
Answers were Sorted based on User's Feedback
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 |
Answer / premraj
alter table table_name add c4 varchar2(30) default null
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / asraf
ALTER TABLE DUMMY1 ADD (C4 VARCHAR2(100) DEFAULT 0)
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / gayathri
Alter table tablename ADD(columnname (data_type) notnull)
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
Explain how exception handling is done in advance pl/sql?
define join and explain different type of joins? : Sql dba
how to include character strings in sql statements? : Sql dba
What is the main reason behind using an index?
Can you join views in sql?
Types of locks in database ?
What is the syntax and use of the coalesce function?
Is sql a backend?
What is the main difference between sql and pl/sql?
Are stored procedures compiled?
Does mysql support pl sql?
How to select random rows from a table?