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>;

How do I limit the number of rows returned by an oracle query after ordering?

1224

---

What happens if you use a wrong connect identifier?

1140

---

How many memory layers are in the oracle shared pool?

1254

---

What privilege is needed for a user to create indexes in oracle?

1083

---

How can windows applications connect to oracle servers?

1116

---

How to delete a column in an existing table?

1131

---

What is the difference between substr and instr?

1092

---

What is integrity and what is constraint??Explain with example

2341

---

Explain what are the different type of segments?

1003

---

What is a cursor in oracle?

1229

---

How to insert a new row into a table in oracle?

1216

---

What is raw datatype in oracle?

1210

---

How to pass a parameter to a cursor in oracle?

1230

---

How to display employee records who gets more salary than the average salary in the department?

1126

---

what is Single Byte Overhead...?

2613

---