2
*========================================================================<br/>
3
* A package for handling partner related activities like
4
* (adding a new partner, updating partner data, removing a
8
CREATE OR REPLACE PACKAGE flyingfish
12
/** Checking the partner record whether it exists or not.
13
* @param id The ID of the partner we want to check
14
* @return 1 if the partner exists, -1 if it doesn't.
17
FUNCTION check_partner(
27
/* comment - multiline
35
WHENEVER OSERROR SHUTDOWN;
37
-- double dashed comment
41
SELECT * FROM mytable WHERE this = :that;
43
SELECT abs(this),HexToRaw('dead') FROM mytable WHERE this = ?;
45
INSERT INTO mytable(that,that) VALUES ( NULL, 10 );
47
UPDATE mytable SET this = :that;
51
REPLACE INTO mytable VALUES (10,"eleven",'singlequoted');
53
MERGE INTO mytable USING newdata
54
ON mytable.foo = newdata.foo
56
UPDATE SET bar = newdata.bar
63
CREATE OR REPLACE TRIGGER xyz_trg BEFORE INSERT ON mytable;
65
CREATE TABLE mytable (