Answer Posted / sandeep

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

Why does for update in oracle 8 cause an ora-01002 error?

943

---

What is a view and how is it different from a table?

982

---

How to rename an index?

1009

---

What is proxy method?

933

---

What is the maximum limit on the number of columns in a table?

1020

---

What is SQL access advisor in Oracle?

1145

---

How to upsert (update or insert into a table)?

961

---

How to create a new tablespace in oracle?

938

---

How to add a new column to an existing table in oracle?

1080

---

what is port in oracle? how is it related to database application.

1897

---

What is oracle and what are its different editions?

1014

---

How to specify default values in insert statement using oracle?

1053

---

how to make an oracle object

2297

---

Oracle

2325

---

Explain the function of optimizer in oracle?

1070

---