Posted By: BigFoot (In Your Room) on 'CZdatabases' Title: Oracle newbie Q3 (PL/SQL) Date: Tue Jan 30 16:54:01 2001 Zdarek (projistotu: ) Nasledujici procedure ma za ukol vypsat na vystup obsah PL/SQL TABLE zadane v parametru ... CREATE OR REPLACE PROCEDURE disp_table (table_in IN <table type>) IS BEGIN FOR table_row IN 1 .. 99 LOOP dbms_output.put_line ('Values are - ' || to_char (table_row) || ': ' || table_in (table_row)); END LOOP; END; / Misto "<table type>" se ma doplnit typ vstupni tabulky. Z cehoz jsem tezce zmaten. Jaky muze mit tabulka typ ? (Podle SELECT * FROM CAT; by do tabulek spadaly i sequence, ale to je (hadam) zase o necem jinem.) BigFoot, aka Yaroukh; yaroukh@email.cz "Budiz svetlo", rekl Booh - a bylo svetlo ... "Budiz k nicemu", rekl Booh - and here I am ! 8}__ __ _