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;

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

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

0 Answers  

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers   jusco,

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

whats the difference between join command and Cartesian product using example?

1 Answers  

---

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

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

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---