Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL Problem

Re: PL/SQL Problem

From: frank <fbortel_at_home.nl>
Date: Mon, 23 Oct 2000 15:42:02 GMT
Message-ID: <39F45C8A.79336BBA@home.nl>

OCP for Developers requires *more* pl/sql knowledge than dba... And calling names will not get you the answer, either.

Frank

VampireD wrote:

> Read my post to the other wise ass.
>
> OCP = 1% PL/SQL.
> That is programmer not database administrator.
>
> Anyway, I don't have any means to keep it that way, I want to learn
> PL/SQL alot better as well. But that no means doesn't mean I can't
> tune/setup/install/troubleshoot an Oracle database, which IS in fact
> what OCP is.
>
> Any other wise ass remarks?
>
> In article <8sqel7$ekt$1_at_spiney.sierra.com>,
> "Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote:
> > 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.
> > >
> > >
> >
> >
>
> --
> Christopher R. Spence
> OCP, MCP, MCSE, A+, RAPTOR, CNA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 23 2000 - 10:42:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US