Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 1-10 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

302	Yii2	Sessions	Werte in Session speichern und lesen	\Yii::$app->session->set('user.attribute',$value); \Yii::$app->session->get('user.some_attribute');
301	PL/pgSQL	Array	Über alle Array-Elemente interieren	DO $do$ DECLARE m text[]; arr text[] := '{{key1,val1},{key2,val2}}'; -- array literal BEGIN FOREACH m SLICE 1 IN ARRAY arr LOOP RAISE NOTICE 'another_func(%,%)', m[1], m[2]; END LOOP; END $do$; -- --------------------------------------------------------- DO $do$ DECLARE i text; arr text[] := '{key1,key2}'; -- array literal BEGIN FOREACH i IN ARRAY arr LOOP RAISE NOTICE 'another_func(%)', i; END LOOP; END $do$;
300	BigQuery	Datenbank	UPDATE SQL mit JOIN	UPDATE `project.dataset.table1` t1 SET t1.target_column = t2.source_column FROM `project.dataset.table2` t2 WHERE t1.join_key = t2.join_key;
299	PL/pgSQL	Datenbank	Alle Datenbanken	SELECT "oid", datname, -- database name datdba, "encoding", datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl FROM pg_catalog.pg_database WHERE datistemplate = FALSE -- do not list template0, template1, ... ;
298	EXASOL	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DDTHH24:MI:SS.FF3') AS iso_date_string
297	BigQuery	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT FORMAT_TIMESTAMP("%FT%H:%M:%E3S", CURRENT_DATETIME()) AS iso_date_string
296	EXASOL	Datenmengen	Differenzen anzeigen	WITH a AS ( SELECT 1 AS n UNION ALL SELECT 2 AS n UNION ALL SELECT 3 AS n UNION ALL SELECT 4 AS n ), b AS ( SELECT 4 AS n UNION ALL SELECT 5 AS n UNION ALL SELECT 6 AS n UNION ALL SELECT 7 AS n ) SELECT * FROM a EXCEPT -- <------------------------------ SELECT * FROM b
295	BigQuery	Datenbank	Eine Menge B reduziert um Menge A	-- Siehe BigQuery -> Differenzen anzeigen -- https://proglang.meta-grid.com/index.php?r=plItems/view&id=294
294	BigQuery	Datenmengen	Differenzen anzeigen	WITH a AS ( SELECT * FROM UNNEST([1,2,3,4]) AS n ), b AS ( SELECT * FROM UNNEST([4,5,6,7]) AS n ) SELECT * FROM a EXCEPT DISTINCT -- <------------------ SELECT * FROM b
293	BigQuery	Datum, Zeit	Gestriges Datum	SELECT CURRENT_TIMESTAMP() AS today_timestamp , DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY) AS yesterday_as_date