simple problem

#1

hello
I'd like to do sth like this:

declare
a varchar(100);
begin
select version into a from v$instance;
if (a like '10%') then
@ver10.sql
else
@oldver.sql
end if;
end;

how to write something like that in PL/SQL ?

#2

abdoul85 wrote:

Quote:

hello
I'd like to do sth like this:

declare
a varchar(100);
begin
select version into a from v$instance;
if (a like '10%') then
@ver10.sql
else
@oldver.sql
end if;
end;

how to write something like that in PL/SQL ?

Looks good - what did you actually try? And it actually is PL/SQL.

And a question: the @ver10 thing is SQL*Plus - not PL/SQL; why
do you want this in PL/SQL when it will not work?
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

#3

well, I have two scripts, one suitable for 10 oracle verison, second
for older. And I wan't the code check the oracle database version and
run ver10.sql or older.sql

#4

On Mon, 15 Oct 2007 16:03:15 +0000, abdoul85 wrote:

Quote:

hello
I'd like to do sth like this:

declare
a varchar(100);
begin
select version into a from v$instance; if (a like '10%') then
@ver10.sql
else
@oldver.sql
end if;
end;

how to write something like that in PL/SQL ?

It should work. Post the error you get.

(And if you intend to install 11g, you'll have to update your test
condition.)

#5

On Oct 15, 1:08 pm, abdoul85 <abdou... (AT) gmail (DOT) com> wrote:

Quote:

well, I have two scripts, one suitable for 10 oracle verison, second
for older. And I wan't the code check the oracle database version and
run ver10.sql or older.sql

Then you code the exact statements you want executed in the PL/SQL
block, as you cannot call a script from within PL/SQL.

David Fitzjarrell

#6

abdoul85 wrote:

Quote:

hello
I'd like to do sth like this:

declare
a varchar(100);
begin
select version into a from v$instance;
if (a like '10%') then
@ver10.sql
else
@oldver.sql
end if;
end;

how to write something like that in PL/SQL ?

Oracle is not a Microsoft product.

What you wrote is roughly inequivalent to "I'd like to do something
like something I can not code." We have no idea what it is you are
trying to do. Try writing out the business requirement in English.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

simple problem

comp.databases.oracle.misc comp.databases.oracle.misc

simple problem - 10-15-2007 , 11:03 AM

Re: simple problem - 10-15-2007 , 12:39 PM

Re: simple problem - 10-15-2007 , 01:08 PM

Re: simple problem - 10-15-2007 , 01:28 PM

Re: simple problem - 10-16-2007 , 01:17 PM

Re: simple problem - 10-17-2007 , 01:10 AM