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

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

What's dateware house and what's clustor with practicle example

0 Answers  

---

What is ordinary table in oracle?

0 Answers   MCN Solutions,

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---

How to initialize variables with default values?

0 Answers  

---

What is oracle database 10g express edition?

0 Answers  

---

What are the uses of Database Trigger ?

0 Answers  

---

What is a Data Segment ?

3 Answers  

---

What is a sub query? Describe its types?

0 Answers  

---

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---

How can we create the complete backup of data in the oracle.

0 Answers   IPEC, Satyam, SunTec,

---

What is where clause in oracle?

0 Answers  

---