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 ddl statements in oracle?
what are the different types of cursors? explain?
When do you get a .pll extension in oracle? Explain its importance
How to get last row id?
Use of an integrity constraint is better to validate data. Explain
what are the default admin accounts in Oracle 10g ?
What is a user role in oracle?
Find all employees in Dept “Marketing”.
Point the difference between translate and replace?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Why use resource manager in Oracle?
How to export your connection information to a file?