単一行を返すストアードプロシジャの例
0001: CREATE PROCEDURE PS_N_SGFO( 0002: SPECIESNAMEIN NCHAR VARYING(40) 0003: ) 0004: RETURNS( 0005: SEQNO INTEGER, 0006: ORDERNAME NCHAR VARYING(24), 0007: ORDERJPN CHAR VARYING(12), 0008: FAMILYNAME NCHAR VARYING(24), 0009: FAMILYJPN CHAR VARYING(20), 0010: GENUSNAME NCHAR VARYING(24), 0011: GENUSJPN CHAR VARYING(12), 0012: SPECIESNAME NCHAR VARYING(40), 0013: SPECIESJPN CHAR VARYING(20), 0014: SPECIESENG NCHAR VARYING(40) 0015: ) 0016: AS 0017: BEGIN 0018: SELECT GENUSNAME, SPECIESNAME, SPECIESJPN, SPECIESENG 0019: FROM SPECIES 0020: WHERE SPECIESNAME=:SPECIESNAMEIN 0021: INTO :GENUSNAME, :SPECIESNAME, :SPECIESJPN, :SPECIESENG; 0022: SELECT FAMILYNAME, GENUSJPN 0023: FROM GENUS 0024: WHERE GENUSNAME=:GENUSNAME 0025: INTO :FAMILYNAME, :GENUSJPN; 0026: SELECT ORDERNAME, FAMILYJPN 0027: FROM FAMILY 0028: WHERE FAMILYNAME=:FAMILYNAME 0029: INTO :ORDERNAME, :FAMILYJPN; 0030: SELECT ORDERJPN 0031: FROM ORDERTAB 0032: WHERE ORDERNAME=:ORDERNAME 0033: INTO :ORDERJPN; 0034: END;
この HTML を検査する。( XHTML 1.0 Strict で書かれています )
Another HTML Lint Gateway ( Mirrored by htmllint.oosato.org )