Oracle Learning 1th, 2 days

Did not expect May full one months not to write essays, I always so, three minutes of heat, it is difficult to stick down. May almost no weekend, are working overtime, evening also often overtime, but fortunately, do not feel tired, but the Dragon Boat festival at home idle down, do not want to go back to work ...

A company project and others to cooperate, the other side is also using. NET development (mainly sliverlight processing graphics), the database is Oracle, it is very magical, has always thought that is. NET with Sqlserver,java with oracle,php with MySQL. Talk to the head of the department, the company may later turn to Oracle, because some projects require Oracle, as well as the increase in data volume, Oracle performance will be better (in fact, SQL Server optimization is sufficient), and in the long run. NET recruit bad recruit want to turn Java (blog Garden of the enduring war of words ... ）。

In any case, self-learning technology is always good. Before looking for a job, afraid of encountering the company with MySQL, have raided the MySQL, and then did not actually use to continue. Now learn Oracle, just as the company has an Oracle environment. I would like to have time to lead a test database to Oracle, and sometimes even Oracle testing, not only in the actual combat, but also not affect the work.

Yesterday saw a half-day video tutorial, think or to remember some points, after good restudying bar.

First, graphical tools: Before the use of PL/SQL Developer, feel that Microsoft SMSs easy to use, good interface dwarfish, and then adjusted the next configuration and plug-ins, feel OK. Yesterday to see the video of SQL Developer, feel not to look good, layout what is more pleasing to the eye. In addition there are on the customer remote machine also saw Toad (continued one second ... ), I don't know how. Before also used Navicat, the advantage is cross-platform, and even three kinds of database is properly, but used not comfortable, feel the function point is too little, sometimes used to temporarily check the data what can also. Finally which tool is easy to use, still have to grope in the actual combat (try to learn to use PL/SQL developer, after all, everyone is used, sometimes remote to other machines, only this tool, not not).

Second, the grammar

The focus of learning, see the video summary, do not know if there is a mistake, the wrong words later found to change it

1, like MySQL, each line to the end of a semicolon, SQL Server although not mandatory, but I usually have a habit (like in JS I will add a semicolon)

2, affirm the variable, MSSQL is declare after the variable is separated by commas, Oracle seems to be separated by semicolons? Watch the video on declare, then wrap each variable one line, ending with a semicolon. Begin the Write statement after the end of the definition

3, reference type, record type: This is really a bunker, I do not know if MSSQL has this kind of function, the feeling that MSSQL is a value type, Oracle can have a reference type, the variable is defined as a table structure or a reference to a field value, which is more like a programming language.

4, spelling string: MSSQL is select Xx.xxx + ' ABC ' from XX, but the Oracle spelling string is not with +, is by | |, like SELECT xx.xxx | | ' ABC ' from XX

Oracle Learning 1th, 2 days