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 i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
How to join two tables in a single query using oracle?
How to define an oracle cursor variable?
Explain user account with reference to oracle.
How to start a new transaction in oracle?
What is difference between SQL and SQL*PLUS?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
which is the best training centre for learning oracle?
Explain the use of ignore option in imp command.
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How to Identify the previously inserted/updated records in already populated table.
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.