0
Still curious? Ask our experts.
Chat with our AI personalities
Fran
Rene
EzraAdd your answer:
Earn +20 pts
How to define a user defined function in SQL?
Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.
Difference between sql function and sql procedure?
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com
What sql function returns the numeric position of a named string?
SUBSTR
Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?
SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S
What is the difference between return 0 and return -1 in c?
If we consider any function that is not the main function that is declared as "bool" i.e it will return boolean values to the main function-0 & 1, meaning 'false' and 'true' respectively. If we have to tell the main function that the condition checked in the function is false or disagreed, then we return 0 to the main function and when we have to tell that the condition checked in the main function is true or agreed, then we return 1 to the main function.
