Search results
10 sty 2012 · It has to do with the Normal Form for the SQL language. IF statements can, by definition, only take a single SQL statement. However, there is a special kind of SQL statement which can contain multiple SQL statements, the BEGIN-END block.
12 wrz 2022 · Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
1 cze 2021 · Remember that you can concatenate only character strings using ||. Use this trick for numbers: SELECT '' || 4 || 2; -- result: 42. Some databases implement non-standard solutions for concatenating strings like CONCAT() or CONCAT_WS(). Check the documentation for your specific database.
2 cze 2021 · Using the new SQL scalar function GENERATE_PDF to create PDF in the IFS from spool files
1 cze 2021 · Standard SQL Functions Cheat Sheet. TEXT FUNCTIONS. CONCATENATION. Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! Remember that you can concatenate only character strings using. ||. Use this trick for numbers: SELECT '' || 4 || 2;
24 maj 2021 · The IF…ELSE structure will execute a certain block of code if a specified condition is TRUE, and a different block of code if that condition is FALSE. Here is the basic layout and syntax of the IF…ELSE structure: IF(<condition is true>) BEGIN <execute some code> END ELSE BEGIN <execute some different code> END
11 kwi 2012 · declare t_rc sys_refcursor; t_query varchar2(1000); begin as_pdf3.init; as_pdf3.load_ttf_font( 'MY_FONTS', 'COLONNA.TTF', 'CID' ); as_pdf3.set_page_proc( q'~ begin as_pdf3.set_font( 'helvetica', 8 ); as_pdf3.put_txt( 10, 15, 'Page #PAGE_NR# of "PAGE_COUNT#' ); as_pdf3.set_font( 'helvetica', 12 ); as_pdf3.put_txt( 350, 15, 'This is a footer text ...
