Re: select part of a string only

On 15 feb, 11:50, "Thiko!" <biwo..._at_hotmail.com> wrote:
> hi i have this text in v$parameter columns name and value:
>
> name: log_archive_dest_1
>
> value: LOCATION=/oraarch/oradata/flash_recovery_area/CPSLIVE/
> archivelog
>
> VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
>
> DB_UNIQUE_NAME=CPSLIVE1p
>
> i do a select to return part of the LOCATION:
>
> select replace(nvl(value,'NULL'),'LOCATION=') from v$parameter where
> name = 'log_archive_dest_1';
>
> this returns:
>
> /oraarch/oradata/flash_recovery_area/CPSLIVE/archivelog
> VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
> DB_UNIQUE_NAME=CPSLIVE1p
>
> Anybody know how i can truncate in my select statement to retrun me
> only '/oraarch/oradata/flash_recovery_area/CPSLIVE/archivelog' and not
> anything after this. i do not wish to include the VALID_FOR etc after
> it.
>
> many thanks.
>
> Thiko!

Use instr() and substr() together.

HTH. Cheers.

Carlos. Received on Thu Feb 15 2007 - 05:01:07 CST