tag:blogger.com,1999:blog-2473156384972050726.post2670633685550939855..comments2024-03-15T00:37:18.503-07:00Comments on Vishal's blog: Non Standard SQL in BIP 11g - Dynamic query implementationVishal Pathakhttp://www.blogger.com/profile/01850811202460421677noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2473156384972050726.post-64651962002890638682021-08-27T03:33:27.536-07:002021-08-27T03:33:27.536-07:00Example to use IF - ESEIF
create sql dataset wit...Example to use IF - ESEIF<br /><br /> create sql dataset with following query<br /> $if{ (:P_MODE == PRODUCT) }$<br /> SELECT PRODUCT_ID<br /> ,PRODUCT_NAME<br /> ,CATEGORY_ID<br /> ,SUPPLIER_ID<br /> ,PRODUCT_STATUS<br /> ,LIST_PRICE<br /> FROM PRODUCT_INFORMATION <br /> WHERE ROWNUM < 5<br /> $elsif{(:P_MODE == ORDER )}$<br /> SELECT ORDER_ID<br /> ,ORDER_DATE<br /> ,ORDER_MODE<br /> ,CUSTOMER_ID<br /> ,ORDER_TOTAL<br /> ,SALES_REP_ID<br /> FROM ORDERS<br /> WHERE ROWNUM < 5<br /> $else{ <br /> SELECT PRODUCT_ID<br /> , WAREHOUSE_ID<br /> ,QUANTITY_ON_HAND<br /> FROM INVENTORIES<br /> WHERE ROWNUM < 5<br /> }$<br /> $endif$Sanjil Jainhttps://docs.oracle.com/middleware/11119/bip/BIPDM/create_data_sets.htm#BABHJCBGnoreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-57469629612370695272018-09-13T23:56:59.206-07:002018-09-13T23:56:59.206-07:00Hi Vishal, can you please tell me what will be the...Hi Vishal, can you please tell me what will be the syntax of if elsif.ambarhttps://www.blogger.com/profile/16787917129192413818noreply@blogger.com