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}__ __ _

Search the boards