Differences

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

--- grandnational [2021/04/25 09:39] – 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 136: / Line 148: @@
        group by name
        order by 2 DESC;
+</code>
+==== Generate Sweepstake ====
+<code plsql>
+set serveroutput on
+BEGIN
+  GenSweepstake();
+END;
+/
 </code>