Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32893 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / anbu
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to assign a tablespace to a users in oracle?
How to write numeric literals in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to use regular expression in pattern match conditions in oracle?
What is index-organized table in Oracle?
How do I call oracle stored procedures that take no parameters?
definition of cluster and non-clustered index?
what is insert all statement in sql
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to convert characters to times in oracle?
What are the types of partitions in oracle?
What is BBED in Oracle?
What is the simplest tool to run commands on oracle servers?
Explain view?
