SQL also supports procedures, which return multiple values.The dept_count function could instead be written as a procedure. Example-1 : Following is a