Use stored-functions for questions related to database specific user-defined functions which can perform queries, accept parameters, and return a computed value.
I was wondering if it is possible in a mysql stored-function or stored-procedure compose a mysql query as a string …
stored-procedures mysql stored-functionsI don't know what is the problem why it gives me error in running the function Here is my sql: …
mysql sql function stored-procedures stored-functionsI'm creating a stored function which should insert new row to table. In this table is also one unique column. …
mysql sql stored-functionsso i have these two tables: -- Table user columns: id,name,surname, password,token,earnedmoney -- Table addlisting columns: …
postgresql triggers plpgsql stored-functionsI am new to PostgreSQL and want to create a database using a stored function. For ex: CREATE OR REPLACE …
database postgresql transactions stored-functionsi've implemented a function that check if a value appears in a specific row of a specific table: CREATE FUNCTION …
sql postgresql stored-procedures stored-functionsI am trying to create a function which would return multiple rows. Following is my function and type create or …
oracle oracle11g stored-functionsI am trying to call an Oracle function from C# that returns multiple rows but it is not working. Here …
sql oracle plsql stored-functionsI've got a vb.net codebase using ado to connect to an Oracle database. We have lots of stored procedures …
oracle stored-procedures ado.net function stored-functionsI am using ado.net. I have a function jsp in my database that takes 2 parameters and returns a table. …
c# database stored-procedures ado.net stored-functions