How do you get all records from 2 tables. Which join do you use?
Answer Posted / sri
UNION ALL
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why truncate is faster than delete?
How do you go back in sql?
What is pl sql in oracle?
Explain ttitle and btitle.
how to extract a unit value from a date and time? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is vector point function?
What is not equal in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Explain the order of sql statement execution?
How many sql statements are used? Define them.
What does sign mean sql?
What is the purpose of design view?
How to find 3rd highest salary of an employee from the employee table in sql?
How to run pl/sql statements in sql*plus?