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 is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

0 Answers  

---

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

---

what is difference between inner join & nested query or subqueries

0 Answers  

---

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

0 Answers  

---

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

---

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  

---

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

Explain an ORA-01555

2 Answers  

---