Answer Posted / guest

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

What is index in Oracle?

1072

---

What do you mean by a deadlock?

1065

---

How can you merge two tables in oracle?

1001

---

What happens to indexes if you drop a table?

1169

---

What is a sub query and what are the different types of subqueries?

1125

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2368

---

How to experiment a data lock in oracle?

1056

---

Explain the difference between sql and oracle?

1076

---

How to get a list of all background sessions in the database?

993

---

Is primary key indexed by default in oracle?

987

---

What is sequence?

1080

---

How do you store pictures in a database?

1003

---

Where do you use decode and case statements?

993

---

6. Display the client name and order date for all orders using the traditional method.

2305

---

What are the differences between interval year to month and interval day to second?

1026

---