How Do I Specify Different Kinds of Names with PL/SQLs Dot Notation?
Dot notation is used for identifying record fields, object attributes, and things inside packages or other schemas. When you combine these things, you might need to use expressions with multiple levels of dots, where it isn’t always clear what each dot refers to. Here are some of the combinations.