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;

What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,

---

Describe the P2P cycle ?

1 Answers  

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers  

---

why r u using etl tool.

2 Answers  

---

How would you determine the time zone under which a database was operating?

1 Answers  

---

3. Steps in UAT?

0 Answers   Oracle,

---

Is it possible to drop a column in a table which contains only one column? How?

1 Answers  

---

which one is currently in used software cmpanies.

0 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---