Hi,
I want to write a plsql script for a quick report with using ampersand symbol, “&”, as a character in the where clause in the code. But when run the report it gives me the error “Invalid member name.” How can I solve it?
Thanks You
Solved
Using ampersand , “&” in plsql as a character
Best answer by Charith Epitawatta
Hi
If what you have is something similar to this:
WHERE name = 'Dungeons & Dragons' You can replace it using the ASCII code for ampersand ‘chr(38)’ like this:
WHERE name = 'Dungeons ' || chr(38) || ' Dragons' I tested this and it worked.
Hope this helps!
This topic has been closed for comments
+19
XitThariK wrote:
Hi,
I want to write a plsql script for a quick report with using ampersand symbol, “&”, as a character in the where clause in the code. But when run the report it gives me the error “Invalid member name.” How can I solve it?
Thanks You
I believe you can use concatenation, as outlined here:
https://community.oracle.com/tech/developers/discussion/468604/escaping-ampersand-in-queries
Good luck!
Joe Kaufman
Just because something is part of a plan doesn't make it right.
+19
/Mino
+31Hi
If what you have is something similar to this:
WHERE name = 'Dungeons & Dragons' You can replace it using the ASCII code for ampersand ‘chr(38)’ like this:
WHERE name = 'Dungeons ' || chr(38) || ' Dragons' I tested this and it worked.
Hope this helps!
Charith - https://charith.pro
1 person likes this
+19Hi
Additiionally I would like to provide a small input from my side.. This is using LIKE clause..
- PL SQL Query
Quick report
select * from customer_info_tab
where name like 'Deals _ Done Limited'
/Mino
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.