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;

How do you add a data file to a tablespace?

1 Answers  

---

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

0 Answers   HCL,

---

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

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

0 Answers  

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  

---

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

0 Answers  

---

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

0 Answers   L&T,

---

the user should know to which database he is connected currently in oracle

3 Answers  

---

default triggers available for reports

0 Answers  

---

What is the difference between recovery and restoring of the oracle database?

0 Answers  

---