What are the locations within a SQL statement from where user-defined functions can be called?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

Practice Test	Free
	1Z0-147 - Oracle9i: Program with PL/SQL	Download

What are the locations within a SQL statement from where user-defined functions can be called?

Rating:

PL/SQL user-defined functions can be called from any place within a SQL expression from where a built-in function can be called. For example, a user-defined function can be called from the following places:

Select list of a SELECT statement

Condition of the WHERE or HAVING clause

CONNECT BY, START WITH, ORDER BY, and GROUP BY clauses

VALUES clause of an INSERT statement

SET clause of an UPDATE statement

Rating:

Was this information helpful?

Click here to Article home

MCSE: MCSA, MCTS, MCITP JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation EC-212-32 CISSP Photoshop ACE Adobe Flash ACE

What are the locations within a SQL statement from where user-defined functions can be called?

What are the locations within a SQL statement from where user-defined functions can be called?

Other articles

Click here to Article home