SQL query to get the string before '@' in an e-mail



select substr ('161ankush037@gmail.com', 1, instr('161ankush037@gmail.com', '@',1,1)-1) str_data from dual;

Comments

Post a Comment

Popular posts from this blog

Oracle Financials Cloud – General Ledger Hierarchies

Image
Oracle Financials Cloud – General Ledger Hierarchies   If your organization uses Hierarchy Structure (specially used by the banking firms) for chart of accounts mapping then most common issue often faced by the business/consultants that child values will start getting populated as parent ones in your OTBI/BIP reports which eventually creates chaos and improper analysis of data.   This issue occurs because hierarchies are defined after uploading the journals through FBDI or after entering the journals into your fusion application resulting in posted balances of child values will be considered as parent level journal balances and it causes reconciliation issues along with hierarchy data misinterpretation.   Below basic points must be taken care while working with Hierarches. 1)       You should create duplicate of hierarchies in order to reduce maintenance and while writing code for your report mention the condition to fetch only cu...
Read more

Oracle Script to Copy Responsibilities of one user account to another user account

fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities to a user account. Please find below the pl/sql block using fnd_user_pkg.addresp API /*******************************************************************************  *PURPOSE: To copy responsibilities of one oracle user account to another oracle user account *  *AUTHOR: Oracle Apps Pie                                                *  *******************************************************************************/ -- -- DECLARE   --   resp_count NUMBER := 0;      CURSOR src_user_resp_details   IS      SELECT DISTINCT fa.application_short_name,       fr.responsibility_key                  ,       fsg.security_group_key,       furga.end...
Read more