Answer Posted / ramesh

create table emp(sal number(5,2);

How to retrieve data from an cursor to a record?

1047

---

How to work with data objects interactively?

935

---

Difference between open_form and call_form in oracle.

1110

---

What is the data type of dual table?

939

---

What is difference between sid and service name in oracle?

919

---

What is truncate oracle?

932

---

How to pass a parameter to a cursor in oracle?

1124

---

How to view the data files in the current database?

1056

---

Is postgres faster than oracle?

982

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1970

---

What is the usage of save points in oracle database?

927

---

What is different types of joins?

987

---

Explain what are the advantages of views?

1026

---

What do you understand by a database object? Can you list a few of them?

987

---

Does oracle charge for java?

1024

---