Answer Posted / sawant

It is area in memory that is used by a Single Oracle User
Process.

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

571

---

Can sub procedure/function be called recursively?

546

---

Can group functions be used in the order by clause in oracle?

586

---

How to use regular expression in pattern match conditions in oracle?

585

---

how to join query for one source type is oracle another source type is sql server ?

1995

---

---

What is data block in Oracle?

626

---

Explain about your project and its relation to the current job position you are applying to?

553

---

What is the simplest tool to run commands on oracle servers?

524

---

How many types of table in Oracle?

625

---

Explain oracle data types with examples?

583

---

When do we use group by clause in a sql query?

579

---

What is a sub query? Describe its types?

553

---

What is null value in oracle?

640

---

How to convert characters to times in oracle?

600

---

Is it possible to insert comments into sql statements return in the data model editor ?

2076

---