PL/SQL equivalent of Select 0, Select 1 etc

[Shay1975]

What is the equivalent of say...

select @somevariable or select 3 in pl/sql?

I am re-writing some existing sprocs in Oracle from SQL server and I need to return the value of a variable in a cursor

OPEN IO_CURSOR FOR
SELECT somevariable

But this is not correct. Does anyone know the correct syntax?

Thanks

[frozenmist]

Hi,

Try
Select 3 from dual
I hope I understood your problem
Cheers

[Shay1975]

I don't understand...essentially I am trying to write the following in PL?SQL

Declare @somevariable int

SET @somevariable = 1

SELECT @somevariable

This will return the value 1 as a recordset

How do you return the value of a variable in PL/SQL?

Thanks

[debasisdas]

Dear Shay

Do u want to return some value through a procedure using PL/SQL



Then write a procedure with out parameters.

[soumya1011]

The equivalent for DECLARE @somevariable int would be
somevariable number;

to initialize it
somevariable:=1;

and you can select its value as
SELECT somevariable FROM dual;

If you want to select some value which is in a table then you can use this
SELECT column_name
INTO somevariable
FROM table_name;