14th Day of Oracle Learning

Today the system officially on the line, busy three months finally some harvest. Special trip to take photos, various opening ceremonies ... Last night, the bus to the station 5:30 this morning.

Tried a few Oracle tools, the native SQL developer interface is good, but the use of a bad. Dbforge for Oracle Most of the mind, but dead and alive can not find the latest cracked version, finally toss a half day only honestly use back PL/SQL Developer

PL/SQL Developer Basic Good, there is the latest version can be used, the scope of application is also wide, the function is strong enough, set options are also many, originally did not have 64 bits, now has 64 bit. There are several deficiencies:

1, I do not know why, enter the program for a long time, enter the settings of the interface will be very long, like suspended animation. At first the suspicion was 64-bit, and the 32-bit was the same. Other on the machine will not be like this, and I do not know whether it is a machine cause or not the right. Fortunately, the main interface is smooth, slow down at first, the settings do not need to change often.

2, can not hide the query out of the data table, there is a shortcut key can be set to "hide the table" and so on, looked like, the actual useless, but can hide the SQL command Line window ... Like MSSQL and Dbforge for Oracle have CTRL + R to hide query results

3, smart tips are not good, can not find any plug-ins. Bring Autoreplace barely make up for the shortfall. Unlike MSSQL SQL prompt plug-ins, can be fuzzy matching, such as to check the ABCD table, as long as the AC, can also match.

Select Smart Prompt is enter, cannot tab, Autoreplace can be tab, also can use space, enter, Ctrl + Enter, but can not define the cursor position, the cursor is at the end each time.

Tonight, I'll look at some of PL/SQL Programming basics, and I've seen another tutorial this time.

1. Basic statement BLOCK:

BEGIN

Dbms_output.put_line (' Test ');

END

But the default is not output, to open the settings: Set serveroutput on;

2, variable: No @, directly declare XX number;

Set the variable without set xx = 123; instead of XX: = 123;

14th Day of Oracle Learning