Forum

Share:

Notifications

Clear all

what are the user-defined functions?

<img alt="kumar BI" alt='' src='https://secure.gravatar.com/avatar/80e771abba56ad3d716bf0366a8ebb93?s=80&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/80e771abba56ad3d716bf0366a8ebb93?s=160&d=mm&r=g 2x' class='avatar avatar-80 photo' height='80' width='80' />

Posts: 12

kumar BI

Topic starter

Aug 04, 2020 10:58 am

(@kumar BI)

Joined: 2 years ago

user-defined functions

Topic Tags

plsqluserdefinedfunctions

1 Reply

<img alt="Siva Kumar" alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' />

Posts: 36

Siva Kumar

Aug 05, 2020 5:16 am

(@Siva Kumar)

Joined: 2 years ago

There are three types of user-defined functions in SQL, namely:

1.Scalar Functions
2.Inline Table-valued functions
3.Multi-statement valued functions

Scalar returns the unit, variant defined the return clause. The other two types of defined functions return table.

Reply

Leave a reply

Share: