Count(*) and Variables in SQL*Plus
From: HaakeFan <haakefan_at_aol.com>
Date: 15 May 1998 00:14:00 GMT
Message-ID: <1998051500140000.UAA19505_at_ladder03.news.aol.com>
[Quoted] This seems so simple, but I'm stumped.
Date: 15 May 1998 00:14:00 GMT
Message-ID: <1998051500140000.UAA19505_at_ladder03.news.aol.com>
[Quoted] This seems so simple, but I'm stumped.
In SQL*Plus, I'm trying to do a record count, and then storing that count to a defined variable. Is that possible? Can I do something that looks like:
DEFINE variable_name = (SELECT COUNT(*) FROM table_name)
Can the variable be defined as a particular number of digits?
Obviously, I'm missing something here. Any help would be greatly appreciated.
Jeff Axelson
Oracle Newbie
Received on Fri May 15 1998 - 02:14:00 CEST