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

how to do daily transactions with out sql* loader control file regesterd in apps?

1225

How does oracle handle read consistency?

680

How to create a table interactively?

562

What is transaction control statement and how many types of transaction control statement in Oracle?

566

How to rename an index?

590

How to save query output to a local file?

563

What happens if you use a wrong connect identifier?

505

How to assign data of the deleted row to variables?

584

How to test null values?

680

Differentiate between pre-select and pre-query?

627

What is the use of file param in imp command?

648

What are privileges and grants?

574

How to run create database statement again?

625

What is blob data type in oracle?

561

Explain the dml?

602