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;

Explain the use of table functions.

0 Answers  

---

Could you please let me know the interfaces in OM / FA??

0 Answers   Oracle,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What are different types of transactions in ar? : oracle accounts receivable

0 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---

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.

0 Answers  

---

What is cardinality?

4 Answers  

---

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

4 Answers  

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

0 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

can u give guidance abt packages of plsql

0 Answers   Mphasis,

---