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 Cross Validation & Adi?

1144

---

types of receipts and detail desription about recipts and tables effected by receipts?

2058

---

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

2173

---

What is an Oracle database Full Backup?

1123

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1190

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2299

---

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.

2171

---

What is mrc and what is its use? : oracle accounts receivable

1183

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

1116

---

Differentiate between transaction type and transaction source? : oracle accounts receivable

1097

---

Why more redos are generated when the oracle database is in begin backup mode?

1107

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1283

---

what are the tools used for oracle 10g in real time.

2427

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1131

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2309

---