Answer Posted / 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;

1. What is PO rate variance gain and loss?

2834

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2221

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1119

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2647

---

8. Supporting AP, AR and GL?

2263

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1248

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2123

---

Difference between transaction type and transaction sources. : oracle accounts receivable

977

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1966

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1257

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1062

---

what are basic modules required to implement oracle application in any oraganisation?

2147

---

What is the use of lockboxes? : oracle accounts receivable

1156

---

Explain about party and customer in ar : oracle accounts receivable

1143

---

What is the difference between oracle media recovery and crash recovery?

1118

---