How to extract single characters in PL/SQL?

From: Ludwig N�rg <noergl_at_gmx.net>
Date: 12 Dec 2002 01:23:06 -0800
Message-ID: <a7148654.0212120123.2e47ca18_at_posting.google.com>

Hi,

[Quoted] [Quoted] I need to split a varchar2 field containing name and first name [Quoted] combined into 2 fields, a blank as separator.

How can I do this in Oracle SQL or PL/SQL?

Any suggestions is helpful.

Thanks
Ludwig N�rg Received on Thu Dec 12 2002 - 10:23:06 CET

This message: [ Message body ]
Next message: Jan Gelbrich: "Re: Forms 5: get_block_property and debugging question"
Previous message: iam_narayanan: "Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem"
Next in thread: Guido Konsolke: "Re: How to extract single characters in PL/SQL?"
Reply: Guido Konsolke: "Re: How to extract single characters in PL/SQL?"
Reply: Alexander Moeckel: "Re: How to extract single characters in PL/SQL?"
Maybe reply: Guido Konsolke: "Re: How to extract single characters in PL/SQL?"
Reply: Tim X: "Re: How to extract single characters in PL/SQL?"
Maybe reply: Sybrand Bakker: "Re: How to extract single characters in PL/SQL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message