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;

What command would you use to create a backup control file?

1 Answers  

---

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

0 Answers  

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

How can you rebuild an index?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

3. Steps in UAT?

0 Answers   Oracle,

---

What is autocashrule set? : oracle accounts receivable

0 Answers  

---

Are These Dff's Flexible?

0 Answers   Oracle,

---

What is index? How many types of indexes?

2 Answers   HCL,

---

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

---

Give the reasoning behind using an index.

2 Answers  

---