How to assign a value to a variable

From: Florian Marinoiu <x_at_x.com>
Date: Wed, 22 Oct 2003 18:05:37 -0400
Message-ID: <3F96FF31.B80C4055_at_x.com>

Hi,

I have the following MS-SQL Server statement that I want to convert to ORACLE 8.1
SET _at_pPhone = '%' + @pPhone + '%'

In ORACLE I tried
SELECT '%' || pPhone || '%' into pPhone from dual;

Where pPhone is a parameter that is passed to the procedure.

How could I do it?

Is it a set in ORACLE?

Thanks,
Florian Received on Thu Oct 23 2003 - 00:05:37 CEST

This message: [ Message body ]
Next message: Daniel Morgan: "Re: How to assign a value to a variable"
Previous message: Stephan Eggermont: "Re: On the subject of Data Warehouses, Data Cubes & OLAP...."
Next in thread: Daniel Morgan: "Re: How to assign a value to a variable"
Reply: Daniel Morgan: "Re: How to assign a value to a variable"
Reply: Florian Marinoiu: "Re: How to assign a value to a variable"

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

Original text of this message