Answer Posted / ajeet singh

For delete any record from table :-

delete form <tablename> where <condition>;


For delete any column fromm table :-

alter table <tablename>
drop column <columnname>;

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1092

---

How to create a new oracle data file?

1074

---

Explain the use of ignore option in imp command.

1082

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2236

---

What are the differences between char and nchar in oracle?

1140

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1089

---

What happens to the current transaction if the session is ended?

1136

---

How to manage transaction isolation level?

1054

---

What to do if the binary spfile is wrong for the default instance?

1106

---

Can multiple cursors being opened at the same time?

1113

---

What is Java Pool in Oracle?

1234

---

Please explain joins in oracle?

1103

---

How to load a large xml file?

1105

---

What is max rowid in oracle?

1079

---

Can we store pictures in the database and if so, how it can be done?

1089

---