Use Scalar Functions Much like other RDBMS and ETL tools, you can use the scalar functions in xSQL to: In this chapter, we’ll show you a few examples. For a […]

INSERT with a Value List Use INSERT statements with literal values to add new rows to a table. For example:   1 SQL> insert into staging.order_item(batch_name, order_code, item_code, incentive...

Sometimes, it is necessary not to leave certain fields empty. Use Nvl() to replace null with another value: 1 SQL> select first_name, Nvl(middle_name, ‘No middle name’) from xactly.xc_p...