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;

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

2511

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2565

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2309

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2066

---

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

1171

---

3. Steps in UAT?

2480

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1223

---

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

2234

---

What is an Oracle database Partial Backup?

1206

---

What is an Oracle database Full Backup?

1175

---

what is difference between inner join & nested query or subqueries

3113

---

Explain the use of table functions.

2583

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7775

---

Difference between negative and positive adjustments : oracle accounts receivable

1162

---

Explain prerequisites and post activities of oracle database installation

2185

---