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 |
What are the different pseudo commands? Explain in general?
How to assign query results to variables?
Can group functions be mixed with non-group selection fields?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What is Network Database link ?
What are the advantages of Views ?
Explain rename?
What is snapshot is too old? Give and example for better understand.
Explain what are the uses of rollback segment?
What are operators in oracle?
How to get a list of all user accounts in the database?
Explain the use of constraints option in exp command.