如何在Oracle PL / SQL where子句中使用变量

variable var number
exec :var := 1

select * from SomeTable where SomeField = :var;

select * from SomeTable where SomeField = :var;

var

result

DECLARE
   var      INT := 1;
   result   INT;
BEGIN
   SELECT 123
     INTO result
     FROM DUAL
    WHERE var = 1;

   DBMS_OUTPUT.put_line (var);
   DBMS_OUTPUT.put_line (result);
END;

DBMS_OUTPUT.PUT_LINE

1
123

declare

  type t_rec is record
  (
  col1 number,
  col2 myTable.col2%type
  );
  v_rec t_rec;

  type t_tab is table of v_rec%type index by binary_integer;
  v_tab t_tab;

begin

  select col1, col2
  bulk collect into v_tab
  from myTable
  where col3 = \'BLAH\';

  -- do something great with v_tab...

end;

select * from sec_mainmenu where serno = \'&MENU_ID\';