A little bit of a feeling about SQL Server and Oracle

2012 using a little Oracle, at that time actually did not really understand the database, it is to use Toad to do some simple management, and then moved to SQL Server began to have some knowledge of the database this thing. Using SQL Server for more than a year, and then began to use Oracle, let me a moment, this time how much should understand the Oracle this big bar, after my use has really found a few different.

SQL Server uses a lot of temporary tables in storage because it helps to manage the edit of the data, but this method is really rare in Oracle, because for Oracle, the temporary table is built with the same resources that are used to build the table, and the pressure on the database is great. Not free to build and release. In fact, I don't quite understand how Oracle handles large aggregate data, and one of the intuitive feelings for me is that Oracle uses a small amount of code to store the structure, while SQL Server is good at using a large number of code storage structures.

Sqlsever is rarely used for triggers, and as for why I did not study it carefully, triggers can help us deal with some fixed rules of incremental data things, oh yes, SQL Server does not use things very much, but this is common in Oracle. Of course, when it comes to data operations, sometimes triggers are not good if they don't understand.

SQL Server I have not seen using cursors, perhaps you would be surprised, when writing code is not write cursors? The cursor is to be written, but in storage, I have not seen the cursor-like extraction data, but this method in Oracle is a big line, Oracle uses cursors to extract data, and then do processing, SQL Server is good at using temporary table processing. But I'm not sure how Oracle calls to store and extract data because it's not covered in the work, and there's time to look into it later.

Know some of the different SQL Server and Oracle, let me have some curiosity about MySQL, but because not often used, but occasionally do some basic use, so the feeling is not deep, because not to be a DBA, I actually do not have much power to study in depth, but as a gossip, I think there's time for me to take a look at it. As for the difference between T-SQL and PL/SQL, it's impossible to say that, just like it's not case-sensitive, and Oracle is strictly case-insensitive and space-like, there are too many subtle places like character. But especially like the toad brought by the monitor mechanism, this hope that SQL Server to seize the effort!!

This article from "Like the wind-like Freedom" blog, declined reprint!

A little bit of a feeling about SQL Server and Oracle