grandnational
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| 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 |
| + | |||
| + | ==== 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; | ||
| + | </ | ||
| ==== Create tables and insert data ==== | ==== Create tables and insert data ==== | ||
| Line 136: | Line 148: | ||
| group by name | group by name | ||
| order by 2 DESC; | order by 2 DESC; | ||
| + | </ | ||
| + | |||
| + | ==== Generate Sweepstake ==== | ||
| + | |||
| + | <code plsql> | ||
| + | set serveroutput on | ||
| + | BEGIN | ||
| + | GenSweepstake(); | ||
| + | END; | ||
| + | / | ||
| </ | </ | ||
grandnational.1619343541.txt.gz · Last modified: 2025/03/08 22:23 (external edit)