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
what are Triggers?
What are different Oracle database objects?
What is an Index Segment ?
What is a nvl function? How can it be used?
What is bulk copy or bcp in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to pass parameters to procedures in oracle?
without using count(*) and rownum how can we count total record in a table
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What are the different types of partitions in oracle?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How can I create database in oracle?