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.
- 1 Answers
- 1862 Views
- TCS, I also Faced
- E-Mail Answers
Answer / Mohd Anwar Khan
"To find the corresponding values in Table B for each row in Table A, we can use a SQL JOIN statement. Here's an example: nnSELECT A.A, B.B FROM Table_A AS A JOIN Table_B AS B ON A.A = B.A;"
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an Extent ?
What are transaction isolation levels supported by oracle?
Name the various constraints used in oracle?
What is a lookup table in oracle?
When do we use group by clause in a sql query?
select * from emp what happened internally when we write this query in the sql prompt?
How to store pictures on to the database?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is PL/SQL ?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What is Network Database link ?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Oracle General 
