Which Datatypes Can Be Used Within Functions That Can Be Invoked In Sql Statements?

Category: QuestionsWhich Datatypes Can Be Used Within Functions That Can Be Invoked In Sql Statements?
Editor">Editor Staff asked 2 years ago

Which Datatypes Can Be Used Within Functions That Can Be Invoked In Sql Statements?

1 Answers
Editor">Editor Staff answered 2 years ago

Stored functions can use valid SQL datatypes, such as NUMBER, VARCHAR2, and DATE. However, they cannot use PL/SQL datatypes, such as BOOLEAN, RECORD, and TYPE.