Re: Another question on Code

Ah, ok - that does helps. Thank you.
I am doing DBMS_SQL stuff now and I noticed there's a few. DBMS_SQL.native <- what does that do ? I can't find anything about it in the chapter or the book I am reading.

-Arthur

>The formal definition is table of <type> where <type> can be either a
>standard type or a record type, defined in your program. And of course, your
>binary integer is the subscript, it is not part of the 'column' defintion.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>"Arthur" <mechhunter_at_rocketmail.com> wrote in message
>news:3a739e5d.75848157_at_news.iinet.net.au...
>> Ah.! implicit.. I was never told about that... crap.
>> Say, can you have more than 2 column within a pl/sql table ?
>> I though you can only have two, a binary integer index and the
>> data colum itself.
>>
>> -Arthur
>>
>> On Sat, 27 Jan 2001 20:27:39 GMT, rr <raineyr_at_look.ca> wrote:
>>
>> >emp_rec is implicity declared as a record type matching job_cur, so in
>> >this case,
>> >job_cur record type is a record type defined as (job.emp%TYPE,
>> >deptno.emp%TYPE)
>> >emp_rec is a variable of that type
>> >rachel
>> >
>> >
>> >Arthur wrote:
>> >
>> >> This work, but see on the line that reads
>> >> FOR emp_rec IN job_cur LOOP...
>> >> What I don't understand is, why was there no need to declare
>> >> emp_rec ????
>> >>
>> >> SET SERVEROUTPUT ON
>> >> DECLARE
>> >> TYPE job_dept_table IS TABLE OF VARCHAR2(60)
>> >> INDEX BY BINARY_INTEGER;
>> >> job_dept job_dept_table;
>> >> v_both VARCHAR2(60);
>> >> x NUMBER:=0;
>> >> v_count NUMBER;
>> >>
>> >> CURSOR job_cur IS
>> >> SELECT DISTINCT job, deptno
>> >> FROM emp
>> >> ORDER BY deptno;
>> >>
>> >> BEGIN
>> >> FOR emp_rec IN job_cur LOOP
>> >> job_dept(x) := to_char(emp_rec.deptno)||(emp_rec.job);
>> >> x:= x+1;
>> >> END LOOP;
>> >>
>> >> DBMS_OUTPUT.put_line(x);
>> >> x:=x-1;
>> >> FOR i IN 1..x LOOP
>> >> DBMS_OUTPUT.PUT_LINE(job_dept(i));
>> >> END LOOP;
>> >>
>> >> END;
>> >> /
>> >>
>> >> Another question, when you have a PL/SQL table.. is there no way you
>> >> can use SELECT using the PL/SQL table within the same code where the
>> >> table was create ?
>> >>
>> >> Many thanks in advance.
>> >>
>> >> Arthur
>> >
>>
>
>
Received on Sun Jan 28 2001 - 09:19:29 CST