Differences

This shows you the differences between two versions of the page.

--- kurs:table_index_by_varchar2 [2010/05/18 11:15]
127.0.0.1 external edit
+++ kurs:table_index_by_varchar2 [2011/11/16 12:52]
mh
@@ Line 1: / Line 1: @@
+<code>
+PROCEDURE teilnehmer_index_by_varchar is
+type teilnehmer_type IS RECORD
+     (name        varchar2(25),
+      geschlecht  varchar2(25));
+TYPE teilnehmer_table_type IS TABLE OF varchar2(25)
+      INDEX BY varchar2(25);
+tn teilnehmer_table_type;
+v_i varchar2(25);
+BEGIN
+tn('Mark') := 'M';
+tn('Karin') := 'W';
+tn('Albert') := 'M';
+tn('Gökhan') := 'M';
+tn('Natalya') := 'W';
+v_i := tn.first;
+while v_i is not null loop
+  dbms_output.put_line(v_i||' '||tn(v_i));
+  v_i := tn.next(v_i);
+end loop;
+END; -- Procedure
+</code>
 <code>
 PROCEDURE SALARY_DIFF_VC

dokuwiki