i have seen in LEFT JOIN RIGHT JOIN INNER JOIN SELF JOIN

Regarding joins what are the differences you observed in
oracle 9i and sql server?

Question Posted / uma

Answer Posted / uma

i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is sql constant?

506

How to make a copy values from one column to another in sql?

572

What is a column in a table?

548

What is a trigger word?

514

How do you optimize a query?

536

What is a natural join sql?

511

Explain normalization and what are the advantages of it?

516

What is the need of a partition key?

530

Explain what is table in a database?

577

Where can I learn sql for free?

505

What is the limitation on the block size of pl/sql?

527

what are the nonstandard string types? : Sql dba

601

What are the types of variable use in pl sql?

564

How do I send sql query results to excel?

577

What is the use of prepared statement?

536