9. Display the client name and order date for all orders
using the JOIN . . . USING method.
Answers were Sorted based on User's Feedback
Answer / devraj
Select ca.name, ora.ordid, Ora.Orderdate From customer ca,
ord Ora Where Ora.Custid = ca.custid;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anjum
select c.name,o.ordid,o.orddate from customer c join oreder o
using(custid);
| Is This Answer Correct ? | 0 Yes | 0 No |
How to drop an index in oracle?
What are the components of physical database structure in the Oracle database?
What is TNS File
How to retrieve first and last records from a table?
What is instant client oracle?
What are a query and state the different types of queries and their uses?
How will you differentiate between varchar & varchar2?
How to define a procedure inside another procedure?
What is self-referential integrity constraint ?
How do I uninstall oracle client from windows?
How to convert a date to char in oracle? Give one example.
Explain coalesce function?