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;

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

1128

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2333

---

how to replace not in with not exist?

3741

---

What view would you use to determine free space in a tablespace?

2224

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2195

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2074

---

what are the API of GL,PO,AP

2273

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2264

---

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

2525

---

what is difference between inner join & nested query or subqueries

3040

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2466

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2327

---

3. Steps in UAT?

2437

---