What is full join?
Answer / Faeem Akhter
A FULL JOIN (or CARTESIAN JOIN) combines all records from both tables, regardless of whether they have a match. If there are no matches, NULL values will be returned for the columns of the missing table.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is rtm stands for?
How does postgresql compare to mysql?
What is the cause of mutating table error and how can we solve it?
Can we insert data into materialized view?
what is the purpose of update command in oracle?
Show the two pl/sql cursor exceptions.
Can dml statements be used in pl/sql?
How can we overcome recursive triggers in SQL?
What is transaction control language (tcl)?
what is the difference between trigger and constraint?
What are the parts of a sql statement?
How can we implement rollback or commit statement in a trigger?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)