In EMP table, for those emp whose Hiredate is same, update
their sal by "sal+500" or else for others keep the sal as it
is, how to do it by SQL query

Answer Posted / sbvp

update emp set sal=sal+500

or
alter table emp modify sal=sal+500

Is This Answer Correct ?    1 Yes 28 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the tasks for which source qualifier transformation is used.

564


According to his methodology what all you need before you build a datawarehouse

1165


explain one complex mapping with logic? sales project?

6099


what are the deliverables?in your project?

1624


Define update strategy?

612






How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

688


Explain joiner transformation in informatica

648


How can we use batches?

578


Explain the etl program with few examples.

521


What is a sequence generator transformation?

555


How can you increase the performance in joiner transformation?

670


Can we create a node as a gateway node and the same node can be assigned to a grid?

619


What is the format of informatica objects in a repository?

579


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1598


Can we get 1st record through Informatica(without sequence number).

941