Answer / sridevi

alter table <table name> modify (columnname newdatatype
(size))

Answer / sridevi

alter table <tablename> add column(col.name(size))

Answer / rajini

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Answer / guest

alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);

Answer / guest

alter table <table name> modify(column definition...);
alter table <table name> add(column definitions...);

Answer / guest

Alter table tablename(data types1,...datatypen)

Answer / suri

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Answer / sandeep

alter table <table_name> add column <Data type of the column>;

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  

How to calculate date and time differences in oracle?

0 Answers  

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

How to delete an existing row from a table in oracle?

0 Answers  

What is a data dictionary and how can it be created?

0 Answers  

What are the factors causing the reparsing of SQL statements in SGA?

2 Answers  

How to add another datafile to a tablespace?

0 Answers  

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

How to find the date and time of last updated table?

4 Answers  

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

What are the roles of dba?

0 Answers