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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to lock and unlock a user account in oracle?

610


What is translate in oracle?

615


What is private procedure oracle?

525


How to define a variable of a specific record type?

606


What is the quickest way to fetch the data from a table?

564






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

601


How to download oracle database 10g xe?

595


What do you mean by merge in oracle?

589


What are the different windows events activated at runtime ?

2408


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1844


How to define a sub function?

660


State and explain about oracle instance?

544


How to add another datafile to a tablespace?

574


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

607


How to retrieve values from data fields in record variables?

563