plsql - Can anyone tell me what is wrong with the following PL/SQL block? -
i trying execute following script in sqlplus each time says "missing keyword". main objective select random number column1 of table variable vnm_rand_number each value(1 8) of column2. please tell me wrong code , there other way me this? declare vvc_sql_stmt long; vvc_name varchar2(10) := 'asdf'; vnm_rand_number number; vvc_table_name varchar2(50); begin vvc_table_name := 'ak_'||vvc_name||''; in 1 .. 8 loop vvc_sql_stmt := 'select column1 vnm_rand_number from( select * '||vvc_table_name||' column2 = '||i||' order dbms_random.value) rownum = 1'; execute immediate (vvc_sql_stmt); commit; dbms_output.put_line(vnm_rand_number); end loop; end; / it's helpful post full error stack (the ora-xxxxx error number, line throwing error, etc.). guess want vvc_sql_stmt := 'select column1 ' || ' from( ' || ' select * ' || ' ' || vvc_table_name || '...