Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: parameterized view

Re: parameterized view

From: <suisum_at_ecn.ab.ca>
Date: 4 Jan 99 05:08:21 GMT
Message-ID: <36904cc5.0@ecn.ab.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US