Answer / phan wai keong

select * from dba_users;

Answer / pradeep

select * from all_users;

How do we switch from init.ora file to asp file?

2 Answers  

---

How to check database size in Oracle?

1 Answers   MCN Solutions,

---

Please explain oracle data types with examples?

1 Answers  

---

What is the parameter mode that can be passed to a procedure?

1 Answers  

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,

---

What is a system tablespace?

1 Answers  

---

What is data file?

1 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

What is the difference between online and offline backups?

1 Answers   MCN Solutions,

---