Select ca.name, ord.orderdate From customer ca Natural Join ord; Natur

8. Display the client name and order date for all orders
using the natural join keywords.

Question Posted / devraj

Answer Posted / devraj

Select ca.name, ord.orderdate From customer ca Natural Join
ord;

Natural join is a cartisn product.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Difference between inner join vs where ?

1043

How to write a query with a right outer join in oracle?

1170

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

1020

Explain the difference between sql and oracle?

1084

How to call a stored function with parameters?

1049

Explain rename?

988

How to create an oracle database manually?

1091

What is system tablespace?

1103

Explain a synonym?

1034

Is the After report trigger fired if the report execution fails ?

2918

What is varray?

1146

What are the execution control statements?

1071

Why do we need oracle client?

959

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2162

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2289