Hi,
you can Use Replace
example :
select replace('Atext-Btext-Ctext-Dtext','text');
CMIIW ^_^
regards
Gie
2010/12/12 gayathri Dev <[email protected]>
> Again, its another issue.
>
> select 'Atext-Btext-Ctext-Dtext' from dual;
>
> Expected Output:
> ABCD.
>
> select 'Atext' from dual;
>
> Expected Output:
> A
>
> select 'Atext-Btext' from dual;
>
> Expected Output:
> AB
>
>
> Want to extract first character after hypen(-)
> I want to achieve this result from Oracle 10g SQL . Please suggest a quick
> option.
>
> Thanks
> `G
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
