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 convert numbers to characters in oracle?
What is memory advisor in Oracle?
What is tns entry?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is the use of aggregate functions in oracle?
What a SELECT FOR UPDATE cursor represent.?
What do you mean by merge in oracle and how can we merge two tables?
How to restrict the duplicate records in table valuesets
What is enter substitution variable in oracle?
What is Database Trigger ?
Explain what are clusters?
what are the differen between key flexifild and discriptive fiexifild.