Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to generate flag in SQL Developer

MOHAMMAD YASEENApr 3 2022 — edited Apr 3 2022

I have a cust_no, acnt_no and currency columns, by using this I have to generate a flag on currency, i.e., if the customer is having multiple accounts with different currency then for USD currency I have to make flag as 1 and for others 0, and if the same customer having multiple accounts with the same currency (USD) then only for single account have to make flag 1 and others 0

Cust_no Acnt_no Currency Desired_Output
121 A25 USD 1
121 A26 USD 0
121 A27 INR 0
122 A23 SAR 1
122 A24 SAR 0
123 A12 USD 0
123 A13 INR 0
123 A14 SAR 1
124 A15 INR 0
124 A16 USD 1
125 A17 INR 0
125 A18 PKR 0
125 A19 USD 1
126 A20 USD 1
127 A21 SAR 1
128 A22 ZAH 0

Comments

683237
After two hours searching on manuals and forums we found the solution: menu Edit L-> launch rules...
Sorry
1 - 1

Post Details

Added on Apr 3 2022
#sql-developer
1 comment
124 views