Answer / Vivek Kumar Katiyar

To delete a column from an existing table, you can use the ALTER TABLE command with the DROP COLUMN clause. The basic command is 'ALTER TABLE your_table DROP COLUMN column_name;'.

What are cursor?where are they used?

2 Answers  

---

Hi Can any one tell me what are the API's used in requisition import.

1 Answers  

---

What is a shared pool?

1 Answers  

---

Explain self joins in oracle?

1 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

What is literal?

1 Answers  

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

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

1 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

How do we switch from init.ora file to asp file?

2 Answers  

---

What is a sub query? Describe its types?

1 Answers  

---