在SQL Developer创建单元测试的过程

〇〇 · 发表于 2011-12-20 12:17

seed翻译成植入，还不如叫播种

〇〇 · 发表于 2011-12-20 12:27

SQL> set feed off
SQL> set timi off
SQL> CREATE TABLE cities
  2 (city_id NUMBER(4,0),
  3    city VARCHAR2(30),
  4    country_abrv VARCHAR2(2)
  5 ) ;

SQL> SQL> CREATE OR REPLACE  PROCEDURE insert_cities (
  2    city_id NUMBER,
  3    city    VARCHAR2,
  4    country_abrv VARCHAR2)
  5 IS
  6 BEGIN
  7    INSERT INTO cities (city_id, city,country_abrv)
  8    VALUES (city_id, city, country_abrv);
  9 END;
10  /

SQL> SQL> CREATE TABLE places
  2 (
  3    location_id NUMBER(4,0),
  4    city VARCHAR2(30),
  5    country_id  CHAR(2)
  6 ) ;
SQL>
SQL> INSERT INTO places  VALUES (1000,'Roma','IT');
SQL> INSERT INTO places  VALUES (1100,'Venice','IT');
SQL> INSERT INTO places  VALUES (1200,'Tokyo','JP');
INSERT INTO places  VALUES (1300,'Hiroshima','JP');
INSERT INTO places  VALUES (1400,'Southlake','US');
SQL> SQL> SQL> INSERT INTO places  VALUES (1500,'South San Francisco','US');
SQL> INSERT INTO places  VALUES (1600,'South Brunswick','US');
SQL> INSERT INTO places  VALUES (1700,'Seattle','US');
SQL> INSERT INTO places  VALUES (1800,'Toronto','CA');
SQL> INSERT INTO places  VALUES (1900,'Whitehorse','CA');
SQL> select count(*) from places;

  COUNT(*)
----------
      10