Is it possible to drop a column in a table which contains only one column? How?
- 1 Answers
- 2800 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain the payment term in ar. : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is the difference between conversions and interfaces? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
How to clone the database using RMAN back
which one is currently in used software cmpanies.
