:global.salary:=:salary1 between :salary2;
execute_query(no_validate);

between is no run i need code

 'where some_column between '||:some_value||' and '||:some_other_value||''

• Set control block's navigation style to "change data block".
  
• Create WHEN-NEW-BLOCK-INSTANCE trigger on the EMP block as

  if :cond.sal_from is not null and :cond.sal_to is not null then
     set_block_property('emp', onetime_where, 'sal between :cond.sal_from and :cond.sal_to');
     execute_query;
  end if;

  
  @JD: you don't have to concatenate values, put everything into a pair of single quotes.
  

DECLARE
c_where VARCHAR2(100);
Blk_Id BLOCK;

BEGIN

c_where := 'last_name like '''|| :your block.last_name_search||'%''';

Blk_Id := find_block('your block');
Set_block_Property (Blk_Id , default_where, c_where);
execute_query;

END;

this code not running.

i have F_name(text_item) and table name is employees so what changes will be done???

Blk_Id := find_block('your block');

in this code cant understand last_name and :your block.last_name__search.