Plpgsql

Plpgsql

do
$$
Declare
Nome varchar(150);
Begin
	Select c_name into Nome from customer where c_custkey = 1;
	raise notice 'HEllo world %', nome;
end;
$$

0

Plpgsql

do
$$
Declare
Nome varchar(150);
Begin
	Select c_name into Nome from customer where c_custkey = 1;
	raise notice 'HEllo world %', Nome;
end;
$$

0

Similar codes

1 vote154 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote200 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote129 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes141 views1 answer
Find all triggers in database
SQL
1 vote171 views1 answer
How not to sort by average rating
SQL
0 vote159 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote146 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote148 views1 answer
Proc sql not in working
SQL
0 vote141 views1 answer
Write sql query to show the details start from digit
SQL
12 votes137 views4 answers
Mysql ifnull
SQL

Share