+ 2

SQL / MySQL / Oracle? (info needed)

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

1st Aug 2018, 11:33 PM
LoneLySouL
LoneLySouL - avatar
6 odpowiedzi
2nd Aug 2018, 1:00 AM
Amy
+ 1
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.
2nd Aug 2018, 1:23 PM
Mato Baculík
Mato Baculík - avatar
+ 1
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...)
2nd Aug 2018, 3:55 PM
Amy
+ 1
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
3rd Aug 2018, 2:04 PM
Nitin S. Avhad
Nitin S. Avhad - avatar
+ 1
Oracle is the best database in market
4th Aug 2018, 12:03 PM
MUHAMMAD FAISAL RAJ
MUHAMMAD FAISAL RAJ - avatar
0
Thanks for helpin guys. I understood the differences.. Does anyone know where can I learn oracle based Sql?
2nd Aug 2018, 1:27 PM
LoneLySouL
LoneLySouL - avatar