JS async

async function refreshDashboard() { // refresh the Report apex.region("my_report").refresh(); console.log('Refreshing Report (1)'); return 'something'; } async function titleChange() { // Chane title of the Report if ($("#my_report #report_my_report").length){ $("#my_report #my_report_heading").text("There are some rows in the report - woohoo"); } else { $("#my_report #my_report_heading").text("Sorry, no rows to display"); } console.log('Changing title (2)'); return 'something'; } async function changeTitles() { await refreshDashboard(); await titleChange(); } changeTitles();

Concat

Description:

CONCAT function allows you to concatenate only two strings together.




syntax:

Concat(char1,char2);

Concat returns char1 concatenated with char2.

Both char1 and char2 can be any of the datatypes CHAR,VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. 

The string returned is in the same character set as char1.

Its datatype depends on the datatypes of the arguments.

In concatenations of two different datatypes, Oracle Database returns the datatype that results in a lossless conversion.

Therefore, if one of the arguments is a LOB, then the returned value is a LOB. If one of the arguments is a national datatype, then the returned value is a national datatype.

For example:

·         CONCAT(CLOB, NCLOB) returns NCLOB




·         CONCAT(NCLOB, NCHAR) returns NCLOB




·         CONCAT(NCLOB, CHAR) returns NCLOB

·         CONCAT(NCHAR, CLOB) returns NCLOB




This function is equivalent to the concatenation operator (||).

examples:

select concat('Connect ','gad') 

from dual;

select concat(concat('Connect ','gad'),' blog') 

from dual;

INITCAP

Description:

INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.

char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2.

The return value is the same datatype as char.

Syntax:

INITCAP(char)

Examples:

SELECT employee_id, last_name, department_id

FROM   employees

WHERE  last_name = 'higgins';

0 rows selected

The select statement displays the employee number, name, and department number of employee Higgins.

The WHERE clause specifies the employee name 

as higgins.

Because all the data in the EMPLOYEES table is stored in proper case, the name higgins does not find a match in the table,and no rows are selected.

SELECT employee_id, last_name, department_id

FROM   employees

WHERE  last_name = INITCAP('higgins');

The WHERE clause specifies that the employee name in the EMPLOYEES table is compared to INITCAP('higgins') which equal 'Higgins'.

Because both names are now 'Higgins', a match is found and one row is selected.