Oracle中DBMS_SQL解析SQL语句的流程

——————————————————————————–
The flow of procedure calls will typically look like this:

———–
| open_cursor |
———–
|
|
v
—–
————>| parse |
|               —–
|                 |
|                 |———
|                 v         |
|           ————–  |
|——–>| bind_variable | |
|     ^     ————-   |
|     |           |         |
|      ———–|         |
|                 || execute |            ->| define_column |
|              ——-             |    ————-
|                 |————    |          |
|                 |            |    ———-|
|                 v            |              v
|           ————–     |           ——-
|       ->| variable_value |   |  ——>| execute |
|      |    ————–     | |         ——-
|      |          |            | |            |
|       ———-|            | |            |
|                 |            | |            v
|                 |            | |        ———-
|                 || fetch_rows |
|                 |              |        ———-
|                 |              |            |
|                 |              |            v
|                 |              |    ——————–
|                 |              |  | column_value         |
|                 |              |  | variable_value       |
|                 |              |    ———————
|                 |              |            |
|                 |