سؤال بسيط


كيف اسوي CALL FUNCTION IN ORACLE

هناك اكثر من طريقة لاستدعاء دالة ومن اهم هذه الطرق هي عن طريق Select Statement

Ways to Execute Functions

If functions are designed thoughtfully, they can be powerful constructs. Functions can be invoked in the following ways:

As part of PL/SQL expressions: You can use host or local variables to hold the returned value from a function. The first example in the slide uses a host variable and the second example uses a local variable in an anonymous block.

As a parameter to another subprogram: The third example in the slide demonstrates this usage. The get_sal function with all its arguments is nested in the parameter required by the DBMS_OUTPUT.PUT_LINE procedure. This comes from the concept of nesting functions as discussed in the Oracle Database 10g: SQL Fundamentals I course.

As an expression in a SQL statement: The last example shows how a function can be used as a single-row function in a SQL statement.

===============================

راجع الصفحة السابعة فى الدرس الثانى فى الـ Oracle Database 10g Develop PL/SQL Program Units

و بالتوفيق

السلام عليكم
اخ هاني ازا عملت FUNCTION على SQL PLUS
كيف بستدعيه على الفورم ؟