How do you get all records from 2 tables. Which join do you use?
Answer Posted / vinay
use full outer join you can get the records
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain the savepoint statement.
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
what is try_catch block in procedure
What is primary key sql?
What is the limitation on the block size of pl/sql?
What is the maximum number of triggers, you can apply on a single table?
Why do we need sharding?
what is the command used to fetch first 5 characters of the string? : Sql dba
What does subquery mean in sql?
What are the different types of database management systems?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Mention what are different methods to trace the pl/sql code?
When you have to use a default "rollback to" savepoint of plvlog?
What is date functions?
What are sql objects?