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 to start your 10g xe server?

0 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

How to export your own schema?

0 Answers  

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

Can we use bind variables in oracle stored procedure?

0 Answers  

---

Can a primary key contain more than one columns?

2 Answers  

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers   Oracle,

---

what is pragma?

2 Answers  

---

What is program global area (pga) in oracle?

0 Answers  

---

What are Schema Objects ?

2 Answers  

---

what is data abstraction

3 Answers   Semantic Space,

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---