Answer Posted / akn
Inner join is the most common type of join. Inner joins
return all rows from multiple tables where the join
condition is met.
Outer join returns all rows from one table and only those
rows from a secondary table where the joined fields are
equal (join condition is met).
Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
How to write date and time literals in oracle?
What is system global area (sga) in oracle?
How to list all user accounts in oracle?
What are the oracle built-in data types?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is clustered table in Oracle?
How to create a table in a specific tablespace?
How to create a new table in oracle?
why dont we assign not null constraint as table level constraint.
Is there a combination of "like" and "in" in sql?
What is snapshot is too old? Give and example for better understand.
what is meant by magic query
What is oracle in java?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
State all possible different index configurations a table can possibly have?