Adressed code review comments.

jgebal · jgebal · commit 9502f1668133 · 2016-12-15T08:05:27.000Z
diff --git a/examples/RunAllExamples.sql b/examples/RunAllExamples.sql
@@ -24,15 +24,6 @@ prompt RunExpectations
 
 @@RunWithDocumentationReporter.sql
 
---workaround for suite level cache
-declare d date := sysdate; begin loop exit when d != sysdate; end loop; end;
-/
 @@award_bonus/run_award_bonus_test.sql
---workaround for suite level cache
-declare d date := sysdate; begin loop exit when d != sysdate; end loop; end;
-/
 @@between_string/run_betwnstr_test.sql
---workaround for suite level cache
-declare d date := sysdate; begin loop exit when d != sysdate; end loop; end;
-/
 @@remove_rooms_by_name/run_remove_rooms_by_name_test.sql
diff --git a/examples/remove_rooms_by_name/rooms.sql b/examples/remove_rooms_by_name/rooms.sql
@@ -6,7 +6,6 @@ create table rooms (
 create table room_contents (
   contents_key number primary key,
   room_key number,
-  name varchar2(100)
+  name varchar2(100),
+  constraint fk_rooms foreign key (room_key) references rooms (room_key)
 );
-
-alter table room_contents add constraint fk_rooms foreign key (room_key) references rooms (room_key);
