Answer / sudipta santra

select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;

If u have the access of the table dba_data_files

how many columns can a plsql table have

13 Answers   NIIT,

---

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,

---

what is normalisation?what are its uses?

0 Answers  

---

What is DTS and purpose of DTS ?

1 Answers   TCS,

---

What are steps required to ENTER DATA INTO DWH?

2 Answers  

---

How to use "if" statements on multiple conditions?

0 Answers  

---

Where are the settings stored for each instance in oracle?

0 Answers  

---

What are the advantages of oracle 12c?

0 Answers  

---

How can you Enforce Referential Integrity in snapshots ?

1 Answers  

---

What is proxy method?

0 Answers  

---

What is the difference between a primary key & a unique key?

0 Answers  

---

Where do you use decode and case statements?

0 Answers  

---