Answer / sawant

Database buffers are cache in the SGA used to hold the data
blocks that are read from the data segments in the
database such as tables, indexes and clusters
DB_BLOCK_BUFFERS parameter in INIT.ORA decides the size.

how to insert data into partitioned table partition done by Range partition

1 Answers  

---

How are the index updates?

1 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

---

IS it possible to built the oracle database without setting the kernal parameters?

0 Answers   EDS,

---

What is define in oracle?

0 Answers  

---

What is Database Buffers ?

1 Answers  

---

What is a read write transaction in oracle?

0 Answers  

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

Difference between an implicit & an explicit cursor.?

2 Answers  

---

Does a Before form trigger fire when the parameter form is suppressed ?

1 Answers   Oracle,

---

How to drop a stored function?

0 Answers  

---