Lab Sql

SELECT query I am using: SELECT ARRAY[table_name,pg_size_pretty(table_size)] FROM ( SELECT … Read more Array Not Being Returned By Select Query Inside Plpgsql Test Case

In PostgreSQL, what is the difference between a prepared statement and a SQL or PL/pgSQL function, … Read more What Is The Difference Between Prepared Statements And Sql Or Pl/pgsql Functions, In Terms Of Their Purpose?

create or replace FUNCTION test_fun ( p_ref_cur OUT SYS_REFCURSOR, p_a_code … Read more How To Call Oracle Function Which Has Sys_refcursor As Out Parameter

I have four tables: dbo.Projects dbo.Locations (id, location name) dbo.Purpose (id, Purposename) … Read more Create And Execute Function In Sql Server

I have created a table valued return function which returns me a table . here is call of my functio… Read more Pass Parameter In Table Valued Function Using Select Statement

sql2005 This is my simplified example: (in reality there are 40+ tables in here, I only showed 2) … Read more Dynamic Table Design (common Lookup Table), Need A Nice Query To Get The Values

Does Apache Derby have a way of replacing a string with another string? I'm looking for somethi… Read more Replace String In Apache Derby

Whenever I run this along with other sql statements ,it gives an error : CREATE FUNCTION' mus… Read more 'create Function' Must Be The First Statement In A Query Batch