V$ views in CRON SQL*Plus script - shell thinks $xxx is a variable

From: Alan Moorman <alm2_at_XYZemail1.dss.state.va.us>
Date: Wed, 3 Nov 1999 07:26:03 -0500
Message-ID: <XHVT3.1$76.63@dit4..state.va.us>

I'm trying to reference v$session in a cronned SQL*Plus script, but the shell (Korn) seems to think that the "$session" is a shell variable. I've tried enclosing the view name is quotes with same result.

Suggestions? Thanks!!

Here's the basic script:

---

sqlplus -s << END
userid/password

insert into stats
 (select username, status, logon_time, sysdate from "V$SESSION" where username
 like 'KPX%');

END

---

Received on Wed Nov 03 1999 - 06:26:03 CST