Summary of recent Oracle Database learning

This summary is just a few new contacts to make a list, to facilitate later into the study to see

1, constant representation: constant

2, type%Type; example: Table name. Column Name%type;--indicates the type of the variable is the type of this column

3,%rowtype

4. Custom Type A is table of. And Type A is record (..);

5, ForAll cycle is more efficient than for, because the former only switches once the context, and the latter will be in the same number of cycles between multiple contexts.

6, bulk collection into a collection of data at once, more efficient than using a cursor bar, especially in the case of a network is not good. But Bluk collect requires a lot of memory.

7. Dynamic cursor REF CURSOR

8. Parameter Mode in,out

Summary of recent Oracle Database learning