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 10:03] – 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 ==== | ==== Create User ==== | ||
| Line 9: | Line 9: | ||
| GRANT CREATE PROCEDURE TO GRANDNATIONAL; | GRANT CREATE PROCEDURE TO GRANDNATIONAL; | ||
| GRANT CREATE VIEW TO GRANDNATIONAL; | GRANT CREATE VIEW TO GRANDNATIONAL; | ||
| + | GRANT CREATE SEQUENCE TO GRANDNATIONAL; | ||
| GRANT UNLIMITED TABLESPACE TO GRANDNATIONAL; | GRANT UNLIMITED TABLESPACE TO GRANDNATIONAL; | ||
| </ | </ | ||
| Line 147: | 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.1619345030.txt.gz · Last modified: 2025/03/08 22:23 (external edit)