We are bringing a new project in house and whereas previously all our work was on SQL Server the new product uses an oracle back end.
Can anyone advise any crib sheets or such like that gives an SQL Server person like me a rundown of what the major differences are - Would like to be able to get up and running as soon as possible.
Oracle Database ActionsFormerly known as SQL Developer Web, Database Actions brings all of your favorite Oracle Database desktop tool's features and experience to your browser! Run scripts, manage users, create/edit objects, import data, diagnose performance issues, visualize schemas, etc.
The main difference between the two languages is how they handle variables, stored procedures, and built-in functions. PL/SQL in Oracle can group procedures into packages, which cannot be done in MS SQL Server." While PL/SQL is more complex and has more' capabilities,' T-SQL is simpler and easier to use.
SQL Developer can be used to connect to MS SQL Server if jTDS (TDS = https://en.wikipedia.org/wiki/Tabular_Data_Stream[Tabular Data Stream) is installed. Such an installation requires the following steps: Download jTDS from SourceForge, version 1.3. 1 or github, current version 1.3.
Oracle is owned by Oracle Corporation and can run on a wide variety of platforms such as Windows, Linux, Solaris, HP-UX, and OS-X. Oracle supports PL/SQL and SQL language to write queries to access data from its database. SQL Server is owned by Microsoft and can only be used on the Windows platform.
@hamishcmcn
Your assertion that '' == Null is simply not true. In the relational world Null should only ever be read to mean "I don't know". The only result you will get from Oracle (and most other decent databases) when you compare a value to Null is 'False'.
Off the top of my head the major differences between SQL Server and Oracle are:
Everyone else, please help me out and add more.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With