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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

What is a nested table?

0 Answers  


What are the differences between interval year to month and interval day to second?

0 Answers  


What are triggers in oracle?

0 Answers  


write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,


What is a package in oracle?

0 Answers  


Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  


What is Parallel Server ?

3 Answers  


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

0 Answers  


types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  


What are the execution control statements?

0 Answers  


How to see free space of each tablespace?

0 Answers  


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)