Hi, Is there any way I can use Subquery in pl/sql function body returning error text? My condition is, I have to display only those customer records which does not exists in my target table through select list. My expectation is like this if :P1_CUST_NM IN (SELECT cust_nm from customer) then return 'Customer already exist!s!'; end if; return null; How can i do that? Really appreciated. Thanks
Discy Latest Questions
I have created a page which has multiple reports. The first IG report (i.e. Clients) it the starting report. When user click on any column from any page (for example I have 10 pages) then it will display the rest of the reports (i.e. Client Data, Client Address etc). The issue is when user click on a column on page no 4, after refresh it will display page no 1 . Expectation is when user click on any column from any page, the row is highlighted and that page even after refresh. I try my best to find the solution but didn't get any clue. Your help is greatly appreciated. Thanks
MohsinContributor
I created a Editable Interactive grid. My goal is to create a new record and pass a date to one column (i.e. current_date) which automatically use the same date value for other column (i.e. admission_date). How can i achieve that? I am new to Apex and trying to explore different features. I know this can be done through Dynamic Action (Set Value) but i don't know what i suppose to select 'SET TYPE' drop down.