Does SQuirreL not understand "&&" notation?

View: New views
9 Messages — Rating Filter:   Alert me  

Does SQuirreL not understand "&&" notation?

by KARR, DAVID (ATTCINW) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I tried to load a SQL script for Oracle that references variables with
the "&&" notation.  SQuirreL failed to grok it.  Is this a known
limitation?  I'm installing SQL Developer right now to verify the script
works there at least.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by manningr :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

This is an SQL*Plus feature - it is Oracle-specific and not standard
SQL (http://www.orafaq.com/node/515)

I'm not sure, but you may be able to use the SQLParam or SQLReplace
plugins to setup the values for the variables that are in your script.

Rob

On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID (ATTCINW)<dk068x@...> wrote:

> I tried to load a SQL script for Oracle that references variables with
> the "&&" notation.  SQuirreL failed to grok it.  Is this a known
> limitation?  I'm installing SQL Developer right now to verify the script
> works there at least.
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by KARR, DAVID (ATTCINW) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> -----Original Message-----
> From: Robert Manning [mailto:robert.m.manning@...]
> Sent: Tuesday, August 18, 2009 4:19 AM
> To: KARR, DAVID (ATTCINW)
> Cc: squirrel-sql-users@...
> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
> notation?
>
> This is an SQL*Plus feature - it is Oracle-specific and not standard
> SQL (http://www.orafaq.com/node/515)

I had assumed that.  Nevertheless, without this, I can't use SQuirreL to run Oracle scripts.  Isn't there already a provision for database-specific features in the plugins?

> I'm not sure, but you may be able to use the SQLParam or SQLReplace
> plugins to setup the values for the variables that are in your script.

I'll take a look at this.

Thanks.

> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID (ATTCINW)<dk068x@...>
> wrote:
> > I tried to load a SQL script for Oracle that references variables
> with
> > the "&&" notation.  SQuirreL failed to grok it.  Is this a known
> > limitation?  I'm installing SQL Developer right now to verify the
> script
> > works there at least.
> >
> > ---------------------------------------------------------------------
> ---------
> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> > trial. Simplify your report design, integration and deployment - and
> focus on
> > what you do best, core application coding. Discover what's new with
> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squirrel-sql-users@...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by KARR, DAVID (ATTCINW) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> -----Original Message-----
> From: Robert Manning [mailto:robert.m.manning@...]
> Sent: Tuesday, August 18, 2009 4:19 AM
> To: KARR, DAVID (ATTCINW)
> Cc: squirrel-sql-users@...
> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
> notation?
>
> This is an SQL*Plus feature - it is Oracle-specific and not standard
> SQL (http://www.orafaq.com/node/515)
>
> I'm not sure, but you may be able to use the SQLParam or SQLReplace
> plugins to setup the values for the variables that are in your script.

It doesn't appear as if these will help, as they apparently require a specific syntax in the script.

> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID (ATTCINW)<dk068x@...>
> wrote:
> > I tried to load a SQL script for Oracle that references variables
> with
> > the "&&" notation.  SQuirreL failed to grok it.  Is this a known
> > limitation?  I'm installing SQL Developer right now to verify the
> script
> > works there at least.
> >
> > ---------------------------------------------------------------------
> ---------
> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> > trial. Simplify your report design, integration and deployment - and
> focus on
> > what you do best, core application coding. Discover what's new with
> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squirrel-sql-users@...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by manningr :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Actually, the sqlreplace plugin will let you replace *ANY* pattern
with another.  So, for example this works:

SELECT * FROM BIGINT_TYPE_TABLE where MYID = &&val;

when SQL Replace plugin is configured with the following pattern replacement:

&&val = 1

If the scripts only have a few "unique" variables (or non-unique
variables with the same value) then
this could work.

And yes, the Oracle plugin already handles some very common SQL*Plus syntax.
So, you can submit a feature request.  If you can give specific test
cases that would be helpful.

Rob

On Tue, Aug 18, 2009 at 12:04 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote:

>> -----Original Message-----
>> From: Robert Manning [mailto:robert.m.manning@...]
>> Sent: Tuesday, August 18, 2009 4:19 AM
>> To: KARR, DAVID (ATTCINW)
>> Cc: squirrel-sql-users@...
>> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> notation?
>>
>> This is an SQL*Plus feature - it is Oracle-specific and not standard
>> SQL (http://www.orafaq.com/node/515)
>>
>> I'm not sure, but you may be able to use the SQLParam or SQLReplace
>> plugins to setup the values for the variables that are in your script.
>
> It doesn't appear as if these will help, as they apparently require a specific syntax in the script.
>
>> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID (ATTCINW)<dk068x@...>
>> wrote:
>> > I tried to load a SQL script for Oracle that references variables
>> with
>> > the "&&" notation.  SQuirreL failed to grok it.  Is this a known
>> > limitation?  I'm installing SQL Developer right now to verify the
>> script
>> > works there at least.
>> >
>> > ---------------------------------------------------------------------
>> ---------
>> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> > trial. Simplify your report design, integration and deployment - and
>> focus on
>> > what you do best, core application coding. Discover what's new with
>> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> > _______________________________________________
>> > Squirrel-sql-users mailing list
>> > Squirrel-sql-users@...
>> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> >
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by KARR, DAVID (ATTCINW) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> -----Original Message-----
> From: Robert Manning [mailto:robert.m.manning@...]
> Sent: Tuesday, August 18, 2009 2:37 PM
> To: KARR, DAVID (ATTCINW)
> Cc: squirrel-sql-users@...
> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
> notation?
>
> Actually, the sqlreplace plugin will let you replace *ANY* pattern
> with another.  So, for example this works:
>
> SELECT * FROM BIGINT_TYPE_TABLE where MYID = &&val;
>
> when SQL Replace plugin is configured with the following pattern
> replacement:
>
> &&val = 1
>
> If the scripts only have a few "unique" variables (or non-unique
> variables with the same value) then
> this could work.

Oh.  I didn't realize that.  I'll see if I can figure out the doc for it and experiment with that.

> And yes, the Oracle plugin already handles some very common SQL*Plus
> syntax.
> So, you can submit a feature request.  If you can give specific test
> cases that would be helpful.

Ok, thanks.

> On Tue, Aug 18, 2009 at 12:04 PM, KARR, DAVID (ATTCINW)<dk068x@...>
> wrote:
> >> -----Original Message-----
> >> From: Robert Manning [mailto:robert.m.manning@...]
> >> Sent: Tuesday, August 18, 2009 4:19 AM
> >> To: KARR, DAVID (ATTCINW)
> >> Cc: squirrel-sql-users@...
> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
> >> notation?
> >>
> >> This is an SQL*Plus feature - it is Oracle-specific and not standard
> >> SQL (http://www.orafaq.com/node/515)
> >>
> >> I'm not sure, but you may be able to use the SQLParam or SQLReplace
> >> plugins to setup the values for the variables that are in your
> script.
> >
> > It doesn't appear as if these will help, as they apparently require a
> specific syntax in the script.
> >
> >> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID
> (ATTCINW)<dk068x@...>
> >> wrote:
> >> > I tried to load a SQL script for Oracle that references variables
> >> with
> >> > the "&&" notation.  SQuirreL failed to grok it.  Is this a known
> >> > limitation?  I'm installing SQL Developer right now to verify the
> >> script
> >> > works there at least.
> >> >
> >> > ------------------------------------------------------------------
> ---
> >> ---------
> >> > Let Crystal Reports handle the reporting - Free Crystal Reports
> 2008
> >> 30-Day
> >> > trial. Simplify your report design, integration and deployment -
> and
> >> focus on
> >> > what you do best, core application coding. Discover what's new
> with
> >> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> >> > _______________________________________________
> >> > Squirrel-sql-users mailing list
> >> > Squirrel-sql-users@...
> >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >> >
> >

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by manningr :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I feel that I must tell you the help documentation is very terse.
However, it's easy to configure:

File -> Global Preferences -> SQLReplace

add key = value and click 'Save'

Rob

On Tue, Aug 18, 2009 at 5:54 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote:

>> -----Original Message-----
>> From: Robert Manning [mailto:robert.m.manning@...]
>> Sent: Tuesday, August 18, 2009 2:37 PM
>> To: KARR, DAVID (ATTCINW)
>> Cc: squirrel-sql-users@...
>> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> notation?
>>
>> Actually, the sqlreplace plugin will let you replace *ANY* pattern
>> with another.  So, for example this works:
>>
>> SELECT * FROM BIGINT_TYPE_TABLE where MYID = &&val;
>>
>> when SQL Replace plugin is configured with the following pattern
>> replacement:
>>
>> &&val = 1
>>
>> If the scripts only have a few "unique" variables (or non-unique
>> variables with the same value) then
>> this could work.
>
> Oh.  I didn't realize that.  I'll see if I can figure out the doc for it and experiment with that.
>
>> And yes, the Oracle plugin already handles some very common SQL*Plus
>> syntax.
>> So, you can submit a feature request.  If you can give specific test
>> cases that would be helpful.
>
> Ok, thanks.
>
>> On Tue, Aug 18, 2009 at 12:04 PM, KARR, DAVID (ATTCINW)<dk068x@...>
>> wrote:
>> >> -----Original Message-----
>> >> From: Robert Manning [mailto:robert.m.manning@...]
>> >> Sent: Tuesday, August 18, 2009 4:19 AM
>> >> To: KARR, DAVID (ATTCINW)
>> >> Cc: squirrel-sql-users@...
>> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> >> notation?
>> >>
>> >> This is an SQL*Plus feature - it is Oracle-specific and not standard
>> >> SQL (http://www.orafaq.com/node/515)
>> >>
>> >> I'm not sure, but you may be able to use the SQLParam or SQLReplace
>> >> plugins to setup the values for the variables that are in your
>> script.
>> >
>> > It doesn't appear as if these will help, as they apparently require a
>> specific syntax in the script.
>> >
>> >> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID
>> (ATTCINW)<dk068x@...>
>> >> wrote:
>> >> > I tried to load a SQL script for Oracle that references variables
>> >> with
>> >> > the "&&" notation.  SQuirreL failed to grok it.  Is this a known
>> >> > limitation?  I'm installing SQL Developer right now to verify the
>> >> script
>> >> > works there at least.
>> >> >
>> >> > ------------------------------------------------------------------
>> ---
>> >> ---------
>> >> > Let Crystal Reports handle the reporting - Free Crystal Reports
>> 2008
>> >> 30-Day
>> >> > trial. Simplify your report design, integration and deployment -
>> and
>> >> focus on
>> >> > what you do best, core application coding. Discover what's new
>> with
>> >> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> >> > _______________________________________________
>> >> > Squirrel-sql-users mailing list
>> >> > Squirrel-sql-users@...
>> >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> >> >
>> >
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by KARR, DAVID (ATTCINW) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> -----Original Message-----
> From: Robert Manning [mailto:robert.m.manning@...]
> Sent: Tuesday, August 18, 2009 4:50 PM
> To: KARR, DAVID (ATTCINW)
> Cc: squirrel-sql-users@...
> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
> notation?
>
> I feel that I must tell you the help documentation is very terse.
> However, it's easy to configure:
>
> File -> Global Preferences -> SQLReplace
>
> add key = value and click 'Save'

Perfect.  Works like a charm.

Thanks.

> On Tue, Aug 18, 2009 at 5:54 PM, KARR, DAVID (ATTCINW)<dk068x@...>
> wrote:
> >> -----Original Message-----
> >> From: Robert Manning [mailto:robert.m.manning@...]
> >> Sent: Tuesday, August 18, 2009 2:37 PM
> >> To: KARR, DAVID (ATTCINW)
> >> Cc: squirrel-sql-users@...
> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
> >> notation?
> >>
> >> Actually, the sqlreplace plugin will let you replace *ANY* pattern
> >> with another.  So, for example this works:
> >>
> >> SELECT * FROM BIGINT_TYPE_TABLE where MYID = &&val;
> >>
> >> when SQL Replace plugin is configured with the following pattern
> >> replacement:
> >>
> >> &&val = 1
> >>
> >> If the scripts only have a few "unique" variables (or non-unique
> >> variables with the same value) then
> >> this could work.
> >
> > Oh.  I didn't realize that.  I'll see if I can figure out the doc for
> it and experiment with that.
> >
> >> And yes, the Oracle plugin already handles some very common SQL*Plus
> >> syntax.
> >> So, you can submit a feature request.  If you can give specific test
> >> cases that would be helpful.
> >
> > Ok, thanks.
> >
> >> On Tue, Aug 18, 2009 at 12:04 PM, KARR, DAVID
> (ATTCINW)<dk068x@...>
> >> wrote:
> >> >> -----Original Message-----
> >> >> From: Robert Manning [mailto:robert.m.manning@...]
> >> >> Sent: Tuesday, August 18, 2009 4:19 AM
> >> >> To: KARR, DAVID (ATTCINW)
> >> >> Cc: squirrel-sql-users@...
> >> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand
> "&&"
> >> >> notation?
> >> >>
> >> >> This is an SQL*Plus feature - it is Oracle-specific and not
> standard
> >> >> SQL (http://www.orafaq.com/node/515)
> >> >>
> >> >> I'm not sure, but you may be able to use the SQLParam or
> SQLReplace
> >> >> plugins to setup the values for the variables that are in your
> >> script.
> >> >
> >> > It doesn't appear as if these will help, as they apparently
> require a
> >> specific syntax in the script.
> >> >
> >> >> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID
> >> (ATTCINW)<dk068x@...>
> >> >> wrote:
> >> >> > I tried to load a SQL script for Oracle that references
> variables
> >> >> with
> >> >> > the "&&" notation.  SQuirreL failed to grok it.  Is this a
> known
> >> >> > limitation?  I'm installing SQL Developer right now to verify
> the
> >> >> script
> >> >> > works there at least.
> >> >> >
> >> >> > ---------------------------------------------------------------
> ---
> >> ---
> >> >> ---------
> >> >> > Let Crystal Reports handle the reporting - Free Crystal Reports
> >> 2008
> >> >> 30-Day
> >> >> > trial. Simplify your report design, integration and deployment
> -
> >> and
> >> >> focus on
> >> >> > what you do best, core application coding. Discover what's new
> >> with
> >> >> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> >> >> > _______________________________________________
> >> >> > Squirrel-sql-users mailing list
> >> >> > Squirrel-sql-users@...
> >> >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >> >> >
> >> >
> >

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Does SQuirreL not understand "&&" notation?

by manningr :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

And thanks goes to Dieter Engelhardt for writing that plugin :)

Cheers,

Rob

On Tue, Aug 18, 2009 at 7:54 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote:

>> -----Original Message-----
>> From: Robert Manning [mailto:robert.m.manning@...]
>> Sent: Tuesday, August 18, 2009 4:50 PM
>> To: KARR, DAVID (ATTCINW)
>> Cc: squirrel-sql-users@...
>> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> notation?
>>
>> I feel that I must tell you the help documentation is very terse.
>> However, it's easy to configure:
>>
>> File -> Global Preferences -> SQLReplace
>>
>> add key = value and click 'Save'
>
> Perfect.  Works like a charm.
>
> Thanks.
>
>> On Tue, Aug 18, 2009 at 5:54 PM, KARR, DAVID (ATTCINW)<dk068x@...>
>> wrote:
>> >> -----Original Message-----
>> >> From: Robert Manning [mailto:robert.m.manning@...]
>> >> Sent: Tuesday, August 18, 2009 2:37 PM
>> >> To: KARR, DAVID (ATTCINW)
>> >> Cc: squirrel-sql-users@...
>> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> >> notation?
>> >>
>> >> Actually, the sqlreplace plugin will let you replace *ANY* pattern
>> >> with another.  So, for example this works:
>> >>
>> >> SELECT * FROM BIGINT_TYPE_TABLE where MYID = &&val;
>> >>
>> >> when SQL Replace plugin is configured with the following pattern
>> >> replacement:
>> >>
>> >> &&val = 1
>> >>
>> >> If the scripts only have a few "unique" variables (or non-unique
>> >> variables with the same value) then
>> >> this could work.
>> >
>> > Oh.  I didn't realize that.  I'll see if I can figure out the doc for
>> it and experiment with that.
>> >
>> >> And yes, the Oracle plugin already handles some very common SQL*Plus
>> >> syntax.
>> >> So, you can submit a feature request.  If you can give specific test
>> >> cases that would be helpful.
>> >
>> > Ok, thanks.
>> >
>> >> On Tue, Aug 18, 2009 at 12:04 PM, KARR, DAVID
>> (ATTCINW)<dk068x@...>
>> >> wrote:
>> >> >> -----Original Message-----
>> >> >> From: Robert Manning [mailto:robert.m.manning@...]
>> >> >> Sent: Tuesday, August 18, 2009 4:19 AM
>> >> >> To: KARR, DAVID (ATTCINW)
>> >> >> Cc: squirrel-sql-users@...
>> >> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand
>> "&&"
>> >> >> notation?
>> >> >>
>> >> >> This is an SQL*Plus feature - it is Oracle-specific and not
>> standard
>> >> >> SQL (http://www.orafaq.com/node/515)
>> >> >>
>> >> >> I'm not sure, but you may be able to use the SQLParam or
>> SQLReplace
>> >> >> plugins to setup the values for the variables that are in your
>> >> script.
>> >> >
>> >> > It doesn't appear as if these will help, as they apparently
>> require a
>> >> specific syntax in the script.
>> >> >
>> >> >> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID
>> >> (ATTCINW)<dk068x@...>
>> >> >> wrote:
>> >> >> > I tried to load a SQL script for Oracle that references
>> variables
>> >> >> with
>> >> >> > the "&&" notation.  SQuirreL failed to grok it.  Is this a
>> known
>> >> >> > limitation?  I'm installing SQL Developer right now to verify
>> the
>> >> >> script
>> >> >> > works there at least.
>> >> >> >
>> >> >> > ---------------------------------------------------------------
>> ---
>> >> ---
>> >> >> ---------
>> >> >> > Let Crystal Reports handle the reporting - Free Crystal Reports
>> >> 2008
>> >> >> 30-Day
>> >> >> > trial. Simplify your report design, integration and deployment
>> -
>> >> and
>> >> >> focus on
>> >> >> > what you do best, core application coding. Discover what's new
>> >> with
>> >> >> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> >> >> > _______________________________________________
>> >> >> > Squirrel-sql-users mailing list
>> >> >> > Squirrel-sql-users@...
>> >> >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> >> >> >
>> >> >
>> >
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users