Re: PL/SQL Problem

I'm been interviewing candidates for an Oracle position here. Many have "Oracle" certificcation.
Most know nothing.

Perhaps their ceritification program is managed by their support program.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:972062653.4731.0.pluto.d4ee154e_at_news.demon.nl...
> You are an OCP and you don't know the answer and/or how to find the answer
> to this question?
> Shame to the OCP program.
> Check out dbms_sql for version 7.3 and 8.0 and native dynamic sql for 8i,
> all in your pl/sql manual and/or the books of Steven Feuerstein.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
> "VampireD" <vampired_at_my-deja.com> wrote in message
> news:8sprgb$bgn$1_at_nnrp1.deja.com...
> > DECLARE
> >
> > CURSOR get_table_sizes_cur
> > IS
> > SELECT table_name
> > FROM dba_tables
> > WHERE table_name = 'TRADE_HISTORY';
> >
> > row_count NUMBER;
> > tab_name get_table_sizes_cur%ROWTYPE;
> >
> > BEGIN
> >
> > FOR tab_name IN get_table_sizes_cur
> > LOOP
> > SELECT count(*)
> > INTO row_count
> > FROM tab_name;
> > dbms_output.put_line(row_count);
> >
> > EXIT WHEN get_table_sizes_cur%NOTFOUND;
> > END LOOP;
> >
> > END;
> > /
> >
> >
> > How would I get the SELECT to read from tab_name rather than from a
> > particular table?
> >
> > --
> > Christopher R. Spence
> > OCP, MCP, MCSE, A+, RAPTOR, CNA
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Oct 20 2000 - 16:50:18 CDT