Search This Blog

Wednesday, March 20, 2019

Get Before @ Portion From a Email Address

SELECT SUBSTR( :EMAIL, 0, INSTR(:EMAIL,'@')-1) DY_USER_NAME
FROM DUAL ;

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;