declare mysql text; myID integer; begin mysql:='select max( $1 ) from $2'; execute mysql into myID using myFeildName,myTableName; if myID is null or myID=0 then return 1; else return myID+1; end if; end;
DECLARE testvalue1 VARCHAR (20) ; testvalue2 VARCHAR (20) ; BEGIN testvalue1 := 'First Test! ' ; SELECT 'Second Test !' INTO testvalue2 ; INSERT INTO act_ge_bytearray SELECT 'Hello World' ; INSERT INTO act_ge_bytearray (DATA) VALUES (testvalue1 || testvalue2) ; END ;
declare area integer := 0; begin area := lenth * height; return area; end