Re: Newbie question about PL/SQL

you could use perl DBI routines.. check www.perl.com's CPAN archives. 'DBD::Oracle'

"Simon Filiatrault" <simon.marie_at_sympatico.ca> wrote in message news:f3kp5.187106$Gh.3411817_at_news20.bellglobal.com...
> Hi all,
>
> All I know for now is sqlplus and how to do a simple select statement....
 I
> want to be able to do something like that:
>
> if (select count() from table) > 100
> then
> update a table
> else
> insert in a table
> end if;
>
> I am trying to do that trough sqlplus on a solaris 7 with oracle 8.05.
> Everthing would be done by a perl script. I want to insert or update
> depending on what's in that table.
>
> Can I use sqlplus to run that kind of program?
>
> I am used to work in sybase, where I can use isql to do that stuff, but it
> seems that sqlplus by itself does not do that...
>
> Any hints would help
>
> Thanks in advance
>
> Simon
>
>
>
>
Received on Fri Aug 25 2000 - 16:56:45 CEST