Answer Posted / anjum

select c.custid,c.name,count(o.ordid) from customer c left
join orders o on c.custid=o.custid group by c.custid;

How to connect to the server with user account: sys?

1002

---

Explain the features of oracle?

1020

---

How to install oracle database 10g xe?

994

---

What is an oracle table?

968

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2013

---

Explain what are the advantages of views?

1048

---

is there a tool to trace queries, like profiler for sql server?

1128

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1987

---

How do you tell what your machine name is and what is its IP address?

2069

---

What is integrity and what is constraint??Explain with example

2255

---

What are the differences between lov and list item?

1043

---

WHAT IS ecc 6.0

2139

---

Calculate difference between 2 date / times in oracle sql?

1027

---

What are the differences between number and binary_float in oracle?

1089

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2943

---