select c.name,o.ordid,o.orddate from customer c join oreder o using(custid

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

Question Posted / anjum

Answer Posted / anjum

select c.name,o.ordid,o.orddate from customer c join oreder o
using(custid);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is flashback in Oracle?

1014

How to install oracle odbc drivers?

1084

What are the tools for Oracle ?

1053

How to use "if" statements on multiple conditions?

1163

Explain the importance of .pll extension in oracle?

997

How to convert csv to table in oracle?

986

What are the different pseudo commands? Explain in general?

1071

What are the various constraints used in oracle?

1037

What is pragma autonomous transaction in oracle?

1058

What is ceil and floor in oracle?

1067

What is the difference between sharding and partitioning?

982

How to invoke the data pump import utility?

1156

How do I connect to oracle database?

1107

What is the usage of save points in oracle database?

960

What happens to indexes if you drop a table?

1163