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 is a database table in oracle?
How to define a variable to match a table column data type?
Define the terms primary key foreign key and also the difference between primary and the unique key
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between formal parameters and actual parameters?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is concurrency in oracle?
How to select an oracle system id (sid)?
what is cartesian product?
What is the use of aggregate functions in oracle?
What is java oracle used for?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?