Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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:
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
![]() |
![]() |