insert/update performance

May I know if there is any performance difference for the following two statement (with and without subquery):

insert into table1 select 'a','b' from dual;

insert into table1 values ('a','b'); Received on Thu Jul 08 1999 - 07:37:27 CDT