Lab Sql

Working with PostgreSQL 9.6.3. I am new to functions in databases. Let's say there are multiple… Read more Pass Table Name Used In From To Function Automatically?

I am just studying how to use SQL in snowflake. Here is a snapshot: And this is the code used in h… Read more How To Use Sql User Defined Function In Snowflake?

I want call function created in SQL Server, which receives two parameters and returns an integer. W… Read more Call Sql Function Using Ado .net

I found a string tokenizer query on the net and packaged it into the below function, which return t… Read more How To Return A Dynamic Result Set In Oracle Function

I have a sql query that I will be reusing in multiple stored procedures. The query works against mu… Read more Reuse Sql With View Or Function

I have the following working DB2 SQL function CREATE OR REPLACE FUNCTION selector (param VARCHAR(3… Read more Db2 Sql Function With Dynamic Return Value

I know there are multiple questions about this same question but I couldn't find one that would… Read more Join Multiple Rows Into One Column Using A Function In Oracle With 3 Related Tables

I have below procedure inside package: PROCEDURE test1 IS InsertST varchar2(32000) : = 'IN… Read more Wrong Symbol Inside Replace Function (pl/sql, Oracle)

I get the following error during postgresql execution: ERROR [HY000] ERROR: you can only use a … Read more Next Value Function Error

Is there a function for MySQL that will count the number of times a string occurs in another string… Read more Sql Function To Get Count Of How Many Times String Appears In Column?

Hi I have this function: CREATE or replace FUNCTION Tablereturn (SWITCHER INTEGER) RETURNS TABLE … Read more Function With Different Returns Db2

Is it possible to call a stored procedure in a user defined function in sql server, mysql or oracle… Read more Is It Possible To Call A Stored Procedure In A User Defined Function ?

Is there any way to call a stored procedure in multi scalar table-valued function like that? Note: … Read more Call A Stored Procedure In Multi Scalar Table-valued Function?

I'm writing code on SQL Server 2014 to pull records for a single day. I will then be using Repo… Read more How To Add Date Range For The Same Day? How To Call Function To Convert Seconds To Hh:mm:ss

I need to extract multiple strings between 2 specific characters that repeats several times in a ro… Read more Get String Between 2 Characters That Repeats Several Times In Sql Server

I am looking for a SQL-function that gives the last 12 months with Start Date and End Date. Say you… Read more Sql Function For Last 12 Months

I am trying to create a function which will return the whole number of periods that have elapsed be… Read more Creating A Duration Function In Sql Server

I am creating a function in my PostgreSQL but I'm getting this syntax error and I ran out of id… Read more Postgresql Stynax Error Creating Function

I am trying to invoke an Oracle stored procedure using the DBMS_SQL.EXECUTE function. I am passing … Read more To_date Issue With Oracle Dbms_sql.execute Function

public String getObjectDetails(String buffer) { dbcon con = new dbcon(); Re… Read more How To Call Stored Function Of In And Out Parameter In Oracle Database Using Java