templates:
- "/path/to/template/default.tmpl"
- "/path/to/template/email.tmpl"{{ define "bla-bla-bla.subject" }}Subject Example{{ end }}
{{ define "bla-bla-bla.html" }}Тут какой-то текст алерта{{ end }}templates:
- "/path/to/template/example.tmpl"
receivers:
- name: "test"
email_configs:
- to: "email@email.mail"
headers:
subject: '{{ "{{" }} template "bla-bla-bla.subject" . {{ "}}" }}'
html: '{{ "{{" }} template "bla-bla-bla.html" . {{ "}}" }}'AS
INSERTED VARCHAR(200);
ID_ NUMBER;
BEGIN
...
BEGIN
SELECT ID_MATERIAL INTO INSERTED FROM SOURCE WHERE SHORTNAME_MATERIAL=SHORT_NAME;
EXCEPTION
WHEN NO_DATA_FOUND THEN NULL ; (или INSERTED := NULL)
END;
...
IF INSERTED IS NULL THEN
...
ELSE
...
END IF ;
...
END <PROCEDURE_NAME> ;update product t
set t.product_code = trim(t.product_code)
where t.product_code != trim(t.product_code);SELECT
c.id
, c.pagetitle
, c.parent
, tv.id
, tv.tmplvarid
, tv.contentid
, tv.value
FROM modx_site_content AS c
RIGHT JOIN modx_site_tmplvar_contentvalues AS tv ON c.id = tv.contentid
WHERE c.parent = 22923
AND ( tv.tmplvarid, tv.value ) IN ( ( 20, 4 ), ( 20, 6 ), ( 19, 10 ) )
ORDER BY c.id ASCid in number
currentSequence NUMBER(10,0);Я верю, что вам платят не за строчки кода. Такое надо объединять в
BEGIN
currentSequence := 0;
currentSequence NUMBER(10,0) := 0 ;
currentSequence := 0;
SELECT
max(vr.CERTIFICATE) INTO currentSequence
FROM
VAGON_REGISTR vr
WHERE
vr.ID = id;
CREATE TABLE table1 ( ID NUMBER, KEY NUMBER ) ;
INSERT INTO table1 ( ID, KEY ) VALUES ( 1, 0 ) ;
INSERT INTO table1 ( ID, KEY ) VALUES ( 2, 1 ) ;
INSERT INTO table1 ( ID, KEY ) VALUES ( 3, 0 ) ;
INSERT INTO table1 ( ID, KEY ) VALUES ( 4, 5 ) ;
INSERT INTO table1 ( ID, KEY ) VALUES ( 5, 4 ) ;
INSERT INTO table1 ( ID, KEY ) VALUES ( 6, 1 ) ;
CREATE TABLE table2 ( ID NUMBER ) ;
INSERT INTO table2 ( ID ) VALUES ( 3 ) ;
INSERT INTO table2 ( ID ) VALUES ( 4 ) ;
INSERT INTO table2 ( ID ) VALUES ( 5 ) ;
INSERT INTO table2 ( ID ) VALUES ( 6 ) ;
COMMIT ;
SELECT UNIQUE t1.key FROM table1 t1, table2 t2 WHERE t1.id = t2.id ;Plan Hash Value : 1501084449
----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | |
| 1 | SORT UNIQUE | | | | | |
| 2 | MERGE JOIN | | | | | |
| 3 | SORT JOIN | | | | | |
| 4 | TABLE ACCESS FULL | TABLE2 | | | | |
| * 5 | SORT JOIN | | | | | |
| 6 | TABLE ACCESS FULL | TABLE1 | | | | |
----------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 5 - access("T1"."ID"="T2"."ID")
* 5 - filter("T1"."ID"="T2"."ID")SQL> SELECT UNIQUE t1.key FROM table1 t1, table2 t2 WHERE t1.id = t2.id ;
KEY
----------
0
1
4
5
SQL>