|
-
The LIKE should be fine in this context.
Generally, I prefer to use an equals because there's the potential for the contents of a variable to include LIKE wildcard characters (_ and %) which can confuse the result
EG
SELECT * from table(sys.dbms_debug_vc2coll ('@test.com','@tast.com','@t_st.com'))
where column_value like '%@t_st.com'
However, I did a quck check and these characters shouldn't be in the domain name so the issue should not arise
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|