Differences

This shows you the differences between two versions of the page.

--- grandnational [2021/04/25 09:37] – z0hpvk
+++ grandnational [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-===== Grand National Sweepstake =====
+===== Grand National Sweepstake (Oracle) =====
+==== Create User ====
+<code sql>
+CREATE USER GRANDNATIONAL IDENTIFIED BY horses;
+GRANT CREATE SESSION TO GRANDNATIONAL;
+GRANT CREATE TABLE TO GRANDNATIONAL;
+GRANT CREATE PROCEDURE TO GRANDNATIONAL;
+GRANT CREATE VIEW TO GRANDNATIONAL;
+GRANT CREATE SEQUENCE TO GRANDNATIONAL;
+GRANT UNLIMITED TABLESPACE TO GRANDNATIONAL;
+</code>
 ==== Create tables and insert data ====
@@ Line 123: / Line 135: @@
 </code>
+==== Create Views ====
+<code sql>
+create or replace view v_sweepstake as
+       select name, horseno, horsename
+       from participants, sweepstake
+       where id = playerid
+       order by horseno;
+create or replace view v_check as
+       select name, count(name) No_Horses from v_sweepstake
+       group by name
+       order by 2 DESC;
+</code>
+==== Generate Sweepstake ====
+<code plsql>
+set serveroutput on
+BEGIN
+  GenSweepstake();
+END;
+/
+</code>