4/4/06

List how a function can be invoked

  • From SQL statement if it has the restrictions.
  • When you call a function from SQL*Plus you need to assign the returned value a bind variable, and you need to EXECUTE command to execute the function like create a SQL*plus environment variable X and issue the command EXECUTE :X := function();

No comments: