9. Display the client name and order date for all orders
using the JOIN . . . USING method.
- 2 Answers
- 3945 Views
- Wipro, I also Faced
- E-Mail Answers
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 can windows applications connect to oracle servers?
Define Normalization with example?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to test null values?
How to start your 10g xe server from command line?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Does oracle partitioning improve performance?
What is an oracle transaction?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
How do we know whether an index is created on a table ???
What is proxy method?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Oracle General 
