what is difference between cartesian join & cross join even
they give same result?
Answer Posted / shilpa
Both the joins give same result.Cross join is SQL 99 join
and Cartesian product is Oracle Propreitary join.
Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What are the different types of failures that occur in Oracle database?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is the data pump import utility?
How to rollback the current transaction in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the minimum client footprint required to connect c# to an oracle database?
How to sort output in descending order in oracle?
What are ddl statements in oracle?
What is SQL Tuning Advisor in Oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to write a query with an inner join in oracle?
How to set a transaction to be read only in oracle?
Where are the settings stored for each instance in oracle?
What is snapshot is too old? Give and example for better understand.