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 supporting issues GL AP and AR?

0 Answers   Oracle,

---

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

0 Answers  

---

8. Supporting AP, AR and GL?

0 Answers   Oracle,

---

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

---

---

please send me oracle pl/sql exp resume. and also faqs...

0 Answers  

---

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,

---

what is correlated subquery

3 Answers  

---

3. Steps in UAT?

0 Answers   Oracle,

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 Answers  

---

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

2 Answers   Ericsson,

---