Difference between join and a subquery?
Answer Posted / maddy
Subquery is also query which returns one or more values we
can retriew the data based on the where contd="IN,ALL"...
subquery is the query followed by the main query....
join is used to join the two table is used to retriew the
data from 1 or more tables.....
| Is This Answer Correct ? | 27 Yes | 12 No |
Post New Answer View All Answers
How to convert times to characters in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are the roles of dba?
Where is the export dump file located?
What are the differences between primary key and unique key?
What is a read only transaction in oracle?
Explain a private synonyms?
What is dynamic proxy?
Describe varray?
Explain oracle data types with examples?
What do you mean by merge in oracle?
How to create lov dynamically at runtime & attach to text field?
How to run create database statement?
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
Is rowid unique in oracle?