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

what is the dual table in oracle?

556

What happens if the update subquery returns multiple rows?

614

How to create an oracle testing table?

596

What is open database communication (odbc) in oracle?

551

Who developed oracle & when?

575

What is instant client oracle?

546

Difference between oracle's plus (+) notation and ansi join notation?

581

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1787

How can we find out the current date and time in oracle?

642

What is data type in oracle?

567

how do u setup a replication site?

1504

What suggestions do you have to reduce the network traffic?

551

How to get the Installed Oracle Version Information ?

628

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1635

What are the database administrators utilities available?

580