Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the naming method of PLSQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Which of the following options correctly describes the definition of plch_part1 and plch_part2 so that the following PLSQL blocks display "Made it this far" after execution in HR SCHEMA?

DECLARE my_list plch_part1.plch_part2: = plch_part1.plch_part2 (); BEGIN my_list.EXTEND; my_list (1): = 'Made it this far'; DBMS_OUTPUT.put_line (my_list (1)); END;/

(A)

A pattern named plch_part1 (SCHEMA) is created. In plch_part1, a nested table named plch_part2 nested table type of VARCHAR2 is created. EXECUTE on plch_part2 is then authorized to HR.

(B)

Create a package named plch_part1 in HR that contains a nested table named plch_part2 nested table type of VARCHAR2.

(C)

A pattern named plch_new_schema (SCHEMA) is created.

Create a package named plch_part1 in plch_new_schema that contains a nested table named plch_part2 nested table type of VARCHAR2.

(D)

A pattern named plch_new_schema (SCHEMA) is created.

Create a package named plch_part1 in plch_new_schema that contains a nested table named plch_part2 nested table type of VARCHAR2.

EXECUTE on plch_part1 is authorized to HR.

Create a synonym named plch_part1 in HR that points to plch_new_schema.plch_part1.

Answer ABD.

C: although HR has the permission to execute plch_part1, it does not create synonyms. You must add the name of OWNER when referencing it:

Plch_new_schema.plch_part1.plch_part2

This is the end of the content of "what is the naming method of PLSQL". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.