MCQs>Database Management>Oracle PL/SQL 9i>A function CALTAX is given below: CREATE OR REPLACE FUNCTION caltax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (sal * 0.05); END CALTAX; Which of the following statements is correct in case you want to run this function from the SQL *Plus prompt?
Oracle PL/SQL 9i MCQs
A function CALTAX is given below: CREATE OR REPLACE FUNCTION caltax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (sal * 0.05); END CALTAX; Which of the following statements is correct in case you want to run this function from the SQL *Plus prompt?
Answer
Correct Answer: You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALTAX(1000);
Explanation:
Note: This Question is unanswered, help us to find answer for this one