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 normalisation?what are its uses?

2274

What is a synonym? What are its various types?

1110

Explain the use of tables option in exp command.

1118

How to use select statement to count the number of rows in oracle?

1046

Explain the difference between a procedure and a function? What do you understand by those terms?

1090

What is bulk load in oracle?

1072

How to use "for" statements in oracle?

1076

How to unlock the sample user account in oracle?

1018

How to use in conditions in oracle?

1058

Point the difference between translate and replace?

1095

How can we view last record added to a table?

1040

How to view the tablespaces in the current database?

981

What are the types of partitions in oracle?

1038

What is bulk copy or bcp in oracle?

1124

How to use "while" statements in oracle?

1328