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

2 Answers
4392 Views
Wipro, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the use of file option in exp command.

1102

What is the implicit cursor in oracle?

1054

How to write date and time interval literals in oracle?

997

How to use "if" statements on multiple conditions?

1127

How do you find current date and time in oracle?

1002

How to create a single index for multiple columns?

992

What is oracle in java?

928

what is reindexing?

1626

State the various uses of dbcc command?

1010

what's query optimization and without use of IN AND Exist can we get another way data from query

2101

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

988

What is background process in Oracle?

1068

What are a query and state the different types of queries and their uses?

971

What is oracle thin client?

986

How to execute a stored program unit?

1023