Re: parameterized view

Hi Thomas:

Thank you very much for your prompt and detail explaanation. I have the following questions in bind variables.

Thomas Kyte (tkyte_at_us.oracle.com) wrote:

: it doesn't stop it, it (the compiler) verifies that the function OBEYS the
: pragma. Consider the following:

<snip>

Very clear. I got it. Thank you.

: Yes. You can use bind variables. Consider: <Snip>

Thank you for the example of using bind variable. I got it. But I have more questions:

1. Can the value of the bind variable passed back to the call from UNIX/NT script?
2. In SQL script, how can I do:

  SELECT COUNT(1) FROM emp;

I want the output such as:

  There are 99 records in the emp table.

Once again, thanks a lot for your wonderful guidance.

Have a nice day. Received on Sun Jan 03 1999 - 23:08:21 CST