Difficulties in shifting from one database to another

Question

Example oracle to mysql, mssql

Answer 1

Not really. You need to understand the core concepts of the Relational Databases: primary keys, foreign keys, relations between tables, indexes, etc. After that everything else is just differences in syntax and terminology.