SQL / MySQL / Oracle? (info needed)

Question

Hi.
So I am learning SQL in uni. Using terminal and then through oracle.. (actually I'm kinda confused)
I thought I would learn SQL fundamentals from here..So i tried.. I wrote (show databses and other staffs) but didn't work on the oracle...

Then in comment i saw someone commenting about Mysql etc..
Can anyone explain why its not working in oracle? and whats the difference between Mssql, SQL or oracle? Isn't it all SQL language?

Thanks in Advance

Answer 1

check it here about the difference => https://www.seguetech.com/microsoft-sql-server-vs-oracle-same-different/

Answer 2

Hi,
SQL is language for managing data in RDBMS. Microsoft (MSSQL) or Oracle (PLSQL) are different vendors of RDBMS, so you can expect slightly different commands when trying to manipulate with objects in db.

Good example is shown here: https://www.w3schools.com/sql/sql_alter.asp

Hope helps a bit.

Answer 3

LoneLySouL if u want to learn sql here is a webpage that it will help you a lot and it has even exercises. 😊 sqlbolt.com (try without www because with "www" it will not open and it says "it isn't safe ect...)

Answer 4

boss
oracle is a relational database product from oracle corporation.
in oracle product they are using sql/plsql language..
ok
now mysql
it is also database and now this is also oracle product bcz oracle by the mysql before buy this is open source and this is mainy familiar with php language
ok and
sql server
this is the Microsoft company product and mainly used for .net
i hope you clear that point for more information all organisations products information. .oracle/Microsoft etc

Answer 5

Oracle is the best database in market

Answer 6

Thanks for helpin guys. I understood the differences..
Does anyone know where can I learn oracle based Sql?