sql server - How to use PL/SQL stored procedure with variable -

i using sql server before, , have task in pl/sql, , seems me oracle totally unlogical, , couldn't find anywhere proper, user friendly documentation.

how write stored procedure similar 1 in sql server:

create procedure test( @x   int ) begin select * table id = @x end 

and if posiible explain logic behind pl/sql script. thank you.

create or replace procedure test (x number) var_table_row table%rowtype; begin select *  var_table_row table id = x; end; 

you need declare row variable store selecting. procedure doesn't make sense @ moment. trying return cursor or something?

edit: i'd use function asking.

create or replace function test (x number) return table%rowtype var_table_row table%rowtype; begin select *  var_table_row table id = x; return var_table_row; end; 

call function this.

declare var_row  table%rowtype; begin var_row := test(2);  --passes two, returns row.  use row var_row.id end;