Answer Posted / pravin

sequence is sharable object in database which is use to
generate unique number
use of sequence is like
insert into table(emp_id,name)values
(sequencname.nextvalue,name)
&
cache is the memory use to how manu values preallocates in
memory & keep in memory defined in cache.
by default 20 values can be stored in cache.

Explain what are the characteristics of data files?

1084

---

Is there any function in oracle similar like group_concat of mysql?

1053

---

How do I uninstall oracle client from windows?

1010

---

how do u setup a replication site?

1982

---

Compare and contrast between sql and sql server and explain its various functions?

959

---

How to pass parameters to procedures?

1032

---

How to drop a stored procedure in oracle?

1051

---

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

2185

---

How do I escape a reserved word in oracle?

1197

---

How to create a new user account in oracle?

1020

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2307

---

Explain the difference between replace() and translate() functions in oracle?

1036

---

How to use subqueries with the in operator using oracle?

1091

---

How many file formats are supported to export data?

1219

---

Explain oracle instance.

1171

---