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;

please explain about oracle

1 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,

---

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

3 Answers  

---

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

0 Answers  

---

what are basic modules required to implement oracle application in any oraganisation?

0 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,

---

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers  

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

---

How can you gather statistics on a table?

3 Answers  

---

What is autocashrule set? : oracle accounts receivable

0 Answers  

---

What is auto invoicing? : oracle accounts receivable

0 Answers  

---

hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.

1 Answers  

---