use Execute immediate statement

make sure you don't set a password when you create the role. otherwise it will promte all the user who ever is using this role to enter the password for...

you may want to use PL/SQL block (begin.... end) like the below..

begin

create statement;

create statement;

end;

If you are using TOAD or any other tool, there is a menu option (under editor) 'execute as acript' (lightning symbol) which will execute all the selected statements as...

if your DBA haven't change the default password for system then use the default password which is 'manager' (system/manager@dbname) then execure the create user command...

use to_date_function...

(to_date('7/6/2003 03:05:00' , 'mm/dd/yyyy hh24:mi:ss')-to_date('7/6/2003 01:18:00' , 'mm/dd/yyyy hh24:mi:ss'))*60*24