Answer Posted / ruchika jena

If u want to drop a table then the command is

drop table <table_name>;

If u want to drop a column_name then the command is

alter table <table_name> drop column <column_name>;

Oracle

1849

---

How to convert characters to numbers in oracle?

596

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1487

---

What do you mean by group by clause?

560

---

How to use "out" parameter properly?

628

---

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

933

---

How to create a new view in oracle?

616

---

What is a server parameter file in oracle?

590

---

How to use existing values in update statements using oracle?

545

---

How to create tables for odbc connection testing?

491

---

Explain the use of compress option in exp command.

547

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1921

---

What do you know about normalization? Explain in detail?

499

---

How to get a list of all background sessions in the database?

540

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2243

---