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

0 vote344 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote332 views2 answers
2nd max salary query in sql
SQL
18 votes314 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
10 votes344 views4 answers
Sql pagination
SQL
1 vote328 views1 answer
Sql injection
SQL
2 votes354 views1 answer
How to find constraints on a table in oracle
SQL
1 vote385 views2 answers
Truncate table sqlite
SQL
2 votes342 views1 answer
Mariadb JSON_EXTRACT
SQL
16 votes337 views4 answers
Mysql import from sql file
SQL
0 vote360 views2 answers
How to take recent row without limit in mysql
SQL

Share