摘要：
ObjectivesAfter completing this lesson,you should be table to do the following:Determine the SQL statements that can be directly included in a PL/SQL executeable block.Manipulate data with DML statements in PL/SQLUse transaction control statements in PL/SQLMake use of the INTO clause to hold the val 阅读全文
摘要：
Nested Tables[表中有表]关联数组，是用在PL/SQL中的一种普通数据类型，无法存储在数据库中；嵌套表既可以在PL/SQL中使用，也可以存储在数据库中.VARRAY可变数组，既可以在PL/SQL中使用，也可以存储在数据库中.Summary of Collection TypesQuizIdentify situations in which you can use the %ROWTYPE attribute.When you are not sure about the structure of the underlying database table.When you wan 阅读全文
摘要：
DECLARE SUBTYPE location_t IS VARCHAR2(64); TYPE population_type IS TABLE OF NUMBER INDEX BY location_t; l_country_population population_type; l_count PLS_INTEGER; l_location location_t;BEGIN l_country_population('Greenland') := 100000; l_country_popu... 阅读全文
摘要：
Associative Arrays(INDEX BY Tables)An associative array is a PL/SQL collection with two columns:Primary Key of integer or string data type(主键可以使整型值，可以使字符串值)Column of scalar or record data typeIOT表表示存储在数据库中的一种数据类型.INDEX BY Table只能用在PL/SQL中，不能存储在数据库中.Associative Array StructureThe Order of Associative 阅读全文