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

Explain view?

1084

Is oracle a programming language?

1035

What happens if the update subquery returns multiple rows?

1163

How to rename a tablespace in oracle?

1123

what are archived logs?

2257

What is the usage of control file in oracle?

1141

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2309

In the oracle version 9.3.0.5.0, what does each number shows?

1343

How do I limit the number of oracle database connections generated by weblogic server?

1113

What is the difference between a primary key & a unique key?

1135

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

2383

What do you understand by a database object? Can you list a few of them?

1061

What is an Oracle index?

1698

Explain the use of parfile option in exp command.

1137

What are a collation and state the different types of collation sensitivity?

1231