Is it possible to drop a column in a table which contains only one column? How?
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
What is auto invoicing? Explain : oracle accounts receivable
What is Tax Categories?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
default triggers available for reports
What view would you use to determine free space in a tablespace?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
What is mrc and what is its use? : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?
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.
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Give two methods you could use to determine what DDL changes have been made.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count