Interested to Buy Any Domain ? << Click Here >> for more details...
8. Display the client name and order date for all orders
using the natural join keywords.
- 1 Answers
- 3568 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / devraj
Select ca.name, ord.orderdate From customer ca Natural Join
ord;
Natural join is a cartisn product.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of database objects?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
What is forall Statement ?
What is a data segment ?
What are data pump export and import modes?
How many memory layers are in the shared pool?
How do I connect to oracle?
What is a tns file?
What are the tools for Oracle ?
How to create a stored procedure in oracle?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
Can you use a commit statement within a database trigger?
Oracle General 
