Disadvantage of user defind function in oracle

Disadvantage of user defined function in oracle.

Disadvantage of UDF in Oracle:

Oracle does not support calling UDFs with Boolean parameters or return types. Users must design them to return numbers such as 0,1 or character strings such as ‘true’,’false’
Significance of cluster table or non cluster table - oracle
Cluster table or non cluster table - A Cluster provides an alternate method of storing table data. It is made up of a group of tables that share the same data...
What is pragma restrict_reference in oracle 9i?
Pragma restrict_reference - Pragma restrict_reference is used to check for violations of any rules applied, at compile time. It’s used in functions to obey some...
Why can't we assign not null constraint as table level constraint?
Not null constraint - Not NULL is a column level constraint to ensure that any value in that column is not null...
Post your comment