Re: parameterized view

Hi Thomas:

Thank you very very much for your guidance. I got it.

Once again, thanks a lot for your great help. Your solution together with the explanation are great.

Thomas Kyte (tkyte_at_us.oracle.com) wrote:

: Not really (passing it back to UNIX or NT). What you can do is something like
: this:

: SQL> set heading off
: SQL> set feedback off
: SQL> select 'There are ' || count(*) || ' records in the emp table' from emp;

: There are 14 records in the emp table

: or, something like:

: SQL> column cnt new_value theCnt
: SQL> select count(*) cnt from emp;

: CNT
: ----------
: 14

: SQL> prompt There are &theCnt records in the table
: There are 14 records in the table
Received on Mon Jan 04 1999 - 09:37:22 CST