Andmebaasid
where partii.turniir =
turniir.id group by Nimi
koduleht
CREATE OR REPLACE FUNCTION sql_html_tabeliks(sql_lause LONG VARCHAR)
RETURNS LONG VARCHAR
BEGIN
DECLARE html_table_pais LONG VARCHAR;
DECLARE xml_paring LONG VARCHAR;
DECLARE temp_tabeli_loomine LONG VARCHAR;
DECLARE temp_tabeli_veerud LONG VARCHAR;
DECLARE vastus LONG VARCHAR;
SELECT
XMLELEMENT(name tr, XMLATTRIBUTES('header' AS class),
XMLAGG (XMLELEMENT(name th, XMLELEMENT(name b, "name")))),
'XMLAGG(XMLELEMENT(name tr, XMLCONCAT(' || list(
'XMLELEMENT(name td, "' || "name" || '")') || '))
order by sa_maintain_order_of_derived_table)',
'declare local temporary table temp_tabel (
sa_maintain_order_of_derived_table int default autoincrement, '
|| list('"' || "name" || '" ' || "domain_name_with_size", ',') || ')',
LIST('"' || "name" || '"', ',')
INTO
html_table_pais,
xml_paring,
temp_tabeli_loomine,
temp_tabeli_veerud
FROM
sa_describe_query(sql_lause);
EXECUTE IMMEDIATE temp_tabeli_loomine;
annaabi.ee 
