Is it possible to drop a column in a table which contains only one column? How?
- 1 Answers
- 2481 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
key flexfield structure
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
which one is currently in used software cmpanies.
Explain the process of recievables in oracle financials. : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What Are Cross Validation & Adi?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
