Search
 
SCRIPT & CODE EXAMPLE
 

SQL

pl/pgsql declare variable

do $$ 
declare
   counter    integer := 1;
   first_name varchar(50) := 'John';
   last_name  varchar(50) := 'Doe';
   payment    numeric(11,2) := 20.5;
begin 
   raise notice '% % % has been paid % USD', 
       counter, 
	   first_name, 
	   last_name, 
	   payment;
end $$;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql alchemy get last n elements 
Sql :: How to write triggers to increment or decrement the number of employees 
Sql :: start whith system mysql 
Sql :: Manage Database in MySQL 
Sql :: sql date time query find 
Sql :: split string update first value in sql server 
Sql :: SQL LEFT JOIN With AS Alias 
Sql :: sql or operator 
Sql :: How to group by week (7 days) in SQL Server 
Sql :: ring get column value from the fetched row using the odbc_getdata() 
Sql :: SQL Copy Table Schema Only 
Sql :: mysql grant user privileges to database that has suffix and prefix 
Sql :: how to type a blank discord messgae 
Sql :: Reduce size of SQL server log file truncate - Source :NAYCode.com 
Sql :: mysql primary vs unique 
Sql :: Shell Comands 
Sql :: update user mysql 
Sql :: match end of string regex sql 
Sql :: sqlite database file android studio 
Sql :: connecting mySQL to STS 
Sql :: Rows, INSERT INTO, Returning with alias 
Sql :: mysql readable output 
Sql :: practice sql queries 
Sql :: sql server interview questions 
Sql :: oracle sql first day of quarter 
Sql :: why do we need data structure in sql 
Sql :: how to subquey to do not load in live database in 
Csharp :: unity set mouse cursor lock 
Csharp :: visual studio c# print to console 
Csharp :: get date of tomorrow c# 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =