RE: Another Oracle sqlplus question
- From: "Good, John" <John.Good@xxxxxxxxxxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Thu, 24 Jul 2008 15:30:13 -0400
Hi,
Google is a very good source for PL.SQL. Use that in the search
parameters and the expression and you should come up with some examples.
Lots of good stuff out there.
I would code it like this:
where su.pay_end_dt > '25-DEC-07'
and su.pay_end_dt < '15-APR-08')
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Eileen
Lafond
Sent: Thursday, July 24, 2008 2:53 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Another Oracle sqlplus question
Hi,
Can someone help me figure out how to correct the following error
message:
where su.pay_end_dt = (> '25-DEC-07'and < '15-APR-08')
*
ERROR at line 15:
ORA-00936: missing expression
I cannot seem to find an example of the correct syntax.
Thanks for any help,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
