Difference between join and a subquery?
Answer Posted / katty
When data is to be retrieved from one table based on the condition from another table subquery is used
When the data is to be retrieved from both the tables join is used
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Explain oracle insert into command?
Describe an oracle table?
What is a static data dictionary in oracle?
What are the differences between date and timestamp in oracle?
How to bring a tablespace online?
How do we display rows from the table without duplicates?
What do you mean by cdb and pdb in oracle 12c?
what is meant by magic query
What is a data lock in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to find the duplicate rows count from employees table in oracle?
Explain mutating triggers.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
material view and view disadvantages?
How to create a stored program unit?