Interested to Buy Any Domain ? << Click Here >> for more details...
9. Display the client name and order date for all orders
using the JOIN . . . USING method.
- 2 Answers
- 4546 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 to increment dates by 1 in oracle?
how many types of index?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to define a variable of a specific record type?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to check the oracle tns settings?
How to define a variable to match a table column data type?
How to drop a stored procedure in oracle?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
How to drop a stored function?
what is Table ?
Oracle General 
