Search:

Try it will work fine:-

Use Router transformation by giving different condition as per ur requirement for each target.

bye

Try it will work fine:-


Use Router transformation by giving different condition as per ur requirement for each target.

cheers

Try this dear it will work fine:-

select replace(dno,substr(dno,2,10),'**********') from dept

Try this dear it will work fine:-

select replace(dno,substr(dno,2,10),'**********') from dept

select max(list_number) from table_name
where list_number not in (select max(list_number) from table_name)


Note: table_name =put name of the table
list_number = column name(containing...

select ename from emp
having count(ename)>1
group by ename