scott@AKSHAY>create or replace procedure MFATTT (tt VARCHAR2) is
  2  begin
  3  
  4  execute immediate 'create view aamir2 as select * from emp';
  5  
  6  end;
  7  /

Procedure created.

Elapsed: 00:00:00.09
scott@AKSHAY>exec mfattt('A');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01
scott@AKSHAY>select object_name,object_type,created from dba_objects where object_name = 'AAMIR2';

OBJECT_NAME                    OBJECT_TYPE        CREATED
------------------------------ ------------------ ---------
AAMIR2                         VIEW               31-MAR-07

Elapsed: 00:00:00.00