Answer / eshwer

No, its not possible to drop all columns.


CREATE TABLE T2(A NUMBER(2));
table T2 created.

alter table
T2
drop column
A;



Error report:
SQL Error: ORA-12983: cannot drop all columns in a table
12983. 00000 - "cannot drop all columns in a table"
*Cause: An attempt was made to drop all columns in a table.
*Action: Make sure at least one column remains in the table after
the drop column operation.

SELECT * FROM T2;

HOW TO SPOT AHIERARCHY?

0 Answers  

---

how to write customizations in po

0 Answers   Ernst Young,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

---

What do you mean by Oracle MEDIA RECOVERY?

0 Answers  

---

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

How can you enable a trace for a session?

2 Answers  

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

---

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  

---

how to replace not in with not exist?

0 Answers   IBM,

---