Select ca.name, ora.ordid, Ora.Orderdate From customer ca, ord Ora Where

9. Display the client name and order date for all orders
using the JOIN . . . USING method.

Question Posted / devraj

Answer Posted / devraj

Select ca.name, ora.ordid, Ora.Orderdate From customer ca,
ord Ora Where Ora.Custid = ca.custid;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to write a query with a right outer join in oracle?

1218

Explain index?

1306

Explain what are the uses of rollback segment?

1064

What is columnar storage what is the advantage?

1119

What are advantages of dateset in datastage?

2304

Can a formula column referred to columns in higher group ?

2550

what is the difference between restoring and recovering?

1051

how to clone 9i Database on to 10g Database.

2383

What are transaction isolation levels supported by oracle?

1112

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2089

What is an oracle cursor variable?

1131

Can a parameter be passed to a cursor?

1179

In oracle there is column command, how will you explain that?

1135

Is there a combination of "like" and "in" in sql?

1114

Is there any function in oracle similar like group_concat of mysql?

1103