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 grant create session privilege to a user in oracle?

945

Oracle

2318

What privilege is needed for a user to create tables in oracle?

900

How would you change old and new values in an insert, delete and update triggers?

950

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2186

Is a rollback possible to any savepoint?

997

Is java required for oracle client?

921

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2771

How to Truncate Table in Oracle

1089

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

978

How to define default values for formal parameters?

980

How to define a variable to match a table column data type?

936

Explain the use of constraints option in exp command.

988

How to get execution statistics reports on query statements?

1004

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

1033