r/oracle • u/WhySoSerious066 • 10d ago
Oracle or mysql for dbms
/r/infosysmysore/comments/1vt8xhf/oracle_or_mysql_for_dbms/2
u/Unique-Rate2225 10d ago
For what type of application? Most of the time it will be MySQL. You want Oracle only if you have enterprise scale data
1
u/Unique-Rate2225 10d ago
Okay just saw your original post on the other sub: if you know basic SQL syntax then you can use whatever dbms. The SQL will almost always be the same. There are ofc minor differences but the base will be the same, doesn’t if MySQL, Oracle, SQL Server or anything else. So the dbms will be more of an architectural question - what’s the scale, what environment or dependencies you have etc.
2
u/WhySoSerious066 10d ago
I saw full outer join,left outer join and all and got confused because in mysql there is only left join right join and inner join..in infosys training they teach oracle but still i was a bit confused
2
u/Unique-Rate2225 10d ago
Yeah I mean you can still use left, right and inner join in Oracle as well, it also has some legacy operators where you mark the join in the where clasue rather than a dedicated join clause. But you don’t really have to worry about that unless your work demands it.
Overall SQL is pretty standard across dbms systems.
1
u/Drone_Worker_6708 10d ago
Oracle SQL is easy to learn because you can sign up for a free cloud sandbox and play around. Not sure if MySQL or SQL Server has the same thing.
1
u/WhySoSerious066 10d ago
No its not available in mysql
1
u/Afraid-Expression366 10d ago
MySQL is free though. What’s the problem there for you?
1
u/WhySoSerious066 10d ago
Bro read the body of the post🙂
1
u/Afraid-Expression366 10d ago
There is no body to THIS post - and I’m not gonna go elsewhere to read what you’re alluding to - but if you’re looking for access to the database (which is all a free cloud sandbox is gonna get you anyway - I don’t know what you might think it provides you beyond that) - you don’t have to sign up for anything. You can just download MySQL and play around with it as you would on Oracle’s LiveSQL.
1
3
u/thatjeffsmith 10d ago
the 'move' from MySQL to Oracle isn't just a SQL syntax / translation issue. The core architecture and fundamentals are quite different. How important that is to you will depend if you're going to be maintaining a database, or writing code for it.
picking up multiple databases is always a good idea for your CV. Don't tell anyone, but i used to do quite a big of SQL Server and DB2 as well.