CREATE OR REPLACE PROCEDURE MYTABLE_TYPE
IS
-- creazione tipo VARRAY
TYPE mytable_type IS TABLE OF VARCHAR2(20) INDEX BY PLS_INTEGER;
mytable mytable_type;
BEGIN
mytable (1):= 'Totti';
mytable (2):= 'Montella';
mytable (3):= 'Cassano';
-- count elementi VARRAY
dbms_output.put_line('numero elementi in mytable = ' || mytable.count);
dbms_output.put_line('valore di mytable ('|| 1 ||') = ' || mytable(1));
FOR i IN 1..mytable.count LOOP
dbms_output.put_line('valore di mytable ('|| i ||') = ' || mytable(i));
END LOOP;
END;
/
Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131
Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale
Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect