select concat (substr(account_number,0,0),lpad(substr(account_number,-4), Length(account_number)-0,'X')) acc_num FROM hz_cust_accounts
WHERE cust_account_id = 3078 -- (cust_id)
WHERE cust_account_id = 3078 -- (cust_id)
Subscribe to:
Post Comments (Atom)
-
I faced some issues when I query the below table data is not fetching in my query: SELECT * FROM hr_operating_units SELECT * FROM MTL_CAT...
-
For this error need to Check RTF template there should be tags are not correctly and if you are developing new RTF latest version. Just se... -
select * from all_objects where object_name like 'GME%BATCH%' and object_type = 'TABLE' --------------------------------...
No comments:
Post a Comment