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 ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1 Answers  

---

What background process refreshes materialized views?

1 Answers  

---

How would you go about increasing the buffer cache hit ratio?

1 Answers  

---

How to find locks exists in a table or not?

1 Answers   HCL,

---

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,

---

What is the sql query to find the employee who has Nth maximum salary?

3 Answers  

---

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

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,

---

How would you force a log switch?

1 Answers  

---

key flexfield structure

1 Answers   Infosys,

---