SET SERVEROUTPUT ON; CREATE OR REPLACE FUNCTION area_of_circle(radius NUMBER) RETURN NUMBER IS v_pi CONSTANT NUMBER := 3.141; v_area NUMBER; BEGIN v_area := v_pi ...

There are three categories for standard oracle SQL functions (not java): string functions, numeric functions and other functions. I think that some functions are misplaced into string functions. Like ...

Abstract: The need for dynamic adaptability in software is growing, driven in part by the emergence of autonomic computing. In many cases, it is desirable to enhance existing programs with adaptive ...

In many large applications, a common way of separating the end user from the schema owner is to use private synonyms for application schema objects. For example, user A and user B both have their own ...

I've got a PL/SQL function that is generating a web page the users can use to manipulate the data in a spreadsheet-like environment.<BR><BR>I need to pass this edited data back to the PL/SQL function ...