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 would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

---

can we use lexical perameter in oracle plsql if yes how

0 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---

why r u using etl tool.

2 Answers  

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---

---

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

---

How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

0 Answers  

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  

---