Difference between oracle's plus (+) notation and ansi join notation?
- 1 Answers
- 1189 Views
- I also Faced
- E-Mail Answers
Answer / Abhay Raja
Oracle's plus (+) notation is a proprietary method for joining tables, while ANSI join notation is the standard SQL syntax for performing table joins. Oracle's plus notation can be faster but may not work in other database systems that don't support it. The ANSI join notation uses the JOIN keyword and supports multiple types of joins (INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER).
| Is This Answer Correct ? | 0 Yes | 0 No |
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What is a nested table and how is it different from a normal table?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
What is an Index ? How it is implemented in Oracle Database ?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
How to use "while" statements in oracle?
What is the difference between hot backup and cold backup in oracle?
what is the difference between oracle enterprise edition and oracle express edition?
Why should I use oracle database?
How to convert character types to numeric types?
how to insert data into partitioned table partition done by Range partition
How to return top 5 rows in oracle?
Oracle General 
