[student] Simple SQL report.

From: Oliver White <ojw_at_iinet.net.au>
Date: Fri, 02 Oct 1998 08:19:30 GMT
Message-ID: <36148b2f.9802512@news.m.iinet.net.au>

Hi, I didn't see the FAQ posted anywhere, but I'm assuming this is the right place to ask for help with oracle SQL.

I'm using Personal Oracle 8 on a wintel machine:

P133
32MB Ram
Win95b

I'm running this report:

---

  1 ACCEPT INITDATE DATE PROMPT 'Enter value for start date: '   2 ACCEPT ENDDATE DATE PROMPT 'Enter value for end date: '   3 SELECT ENAME, HIREDATE
  4 FROM EMP
  5* WHERE HIREDATE BETWEEN &INITDATE AND &ENDDATE;

---

And getting these results:

---

SQL> @GETHIREDATES
Enter value for start date: 1-JAN-81
Enter value for end date: 1-JAN-82
old 3: WHERE HIREDATE BETWEEN &INITDATE AND &ENDDATE new 3: WHERE HIREDATE BETWEEN 1-JAN-81 AND 1-JAN-82 WHERE HIREDATE BETWEEN 1-JAN-81 AND 1-JAN-82

                                      *

ERROR at line 3:
ORA-00904: invalid column name

---

I'm afraid I'm simply stumped as to what the problem is.

Your help appreciated.
--
On the smeeter.
MHM 22x9
-- Received on Fri Oct 02 1998 - 03:19:30 CDT