Example of Dynamic SQL Statment

xname varchar2(10);
begin
execute immediate 'select ename   FROM   employeetest  WHERE  eno=10 and edepartment=''ABC'' '   into xname;
dbms_output.put_line(xname);
end;