Is it possible to drop a column in a table which contains only one column? How?
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;
Is This Answer Correct ? | 1 Yes | 0 No |
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is difference b/w Credit memo and Adjustment in AR.
What command would you use to create a backup control file?
as a technical developer in oracle applications which type errors feced in your experience sofar
HOW TO SPOT AHIERARCHY?
For web applications from which version of Oracle is suitable?
How can you rebuild an index?
what is difference between inner join & nested query or subqueries
Explain the difference between a hot backup and a cold backup and the benefits associated with each