Migration of Session variables from Oracle

[irfan rehman]

hello,

we are using java application on oracle, now we need to migrate one data schema from oracle to MySQL.

my question is can we use the following:

a) can we set session variable in mysql.

b) Support for Stored procedures and triggers in Mysql.

c) Ability to insert/update/delete views.

which we are using in oracle.

does Mysql support?


Thanks