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

What is private procedure oracle?

0 Answers  

What is oracle and what are its different editions?

0 Answers  

Name the three major set of files on disk that compose a database in Oracle?

0 Answers  

What do you mean by a deadlock?

0 Answers  

How do I call oracle stored procedures that take no parameters?

0 Answers  

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

0 Answers  

Can you use a commit statement within a database trigger?

4 Answers  

Explain drop constraint oracle?

0 Answers  

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

What is a Sequence ?

3 Answers  

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 Answers  

DBMS vs. RDBMS

2 Answers   TCS,