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

Can we insert data in view oracle?

531

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

585

How to connect ms access to oracle servers?

548

Can we call procedure inside function in oracle?

604

What are the various constraints used in oracle?

550

What happens if you use a wrong connect identifier?

499

How many types of segments in Oracle?

527

Â What are the oracle DML commands possible through an update strategy?

579

What is an oracle database?

610

What is a proxy class?

555

How to drop an existing view in oracle?

562

How to select all columns of all rows from a table in oracle?

588

Is there an oracle sql query that aggregates multiple rows into one row?

542

Where are the settings stored for each instance in oracle?

621

what is Single Byte Overhead...?

2058