vangogpeter
asked on
sql request
How we will full fill this
if my sql query is
select * from emp;
select /* 10046 */ .. / <<-- to complete with your sql request
Please help me to fullfil the query with out syntax error.
if my sql query is
select * from emp;
select /* 10046 */ .. / <<-- to complete with your sql request
Please help me to fullfil the query with out syntax error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I made an error in the request
this is my sql request not select * from emp;
SELECT sys_user0."name"
FROM PREMDEV_ADMIN.sys_user sys_user0
WHERE (lower(sys_user0."name") LIKE lower('WU%') ESCAPE '\') OR (lower(sys_user0."email") LIKE lower('WU%') ESCAPE '\')
AND (sys_user0."active" = 1)
ORDER BY sys_user0."name";
select /* 10046 */ .. / <<-- to complete with your sql request
{ i got this from online just a help to how to apply this}
Please help me to fullfil the query with out syntax error.
this is my sql request not select * from emp;
SELECT sys_user0."name"
FROM PREMDEV_ADMIN.sys_user sys_user0
WHERE (lower(sys_user0."name") LIKE lower('WU%') ESCAPE '\') OR (lower(sys_user0."email") LIKE lower('WU%') ESCAPE '\')
AND (sys_user0."active" = 1)
ORDER BY sys_user0."name";
select /* 10046 */ .. / <<-- to complete with your sql request
{ i got this from online just a help to how to apply this}
Please help me to fullfil the query with out syntax error.
>>select /* 10046 */ .. / <<-- to complete with your sql request
Sorry but I have no idea what this means.
Can you provide the link where you found this?
Sorry but I have no idea what this means.
Can you provide the link where you found this?
It'd be the same thing:
SELECT /* 10046 <more description to this comment> */sys_user0."name"
FROM PREMDEV_ADMIN.sys_user sys_user0
WHERE (lower(sys_user0."name") LIKE lower('WU%') ESCAPE '\') OR (lower(sys_user0."email") LIKE lower('WU%') ESCAPE '\')
AND (sys_user0."active" = 1)
ORDER BY sys_user0."name";
ASKER
No it is printed out no link.
>>No it is printed out no link.
Then we need to know what it is supposed to do for you.
Again, if it is just a comment in a statement to track it in a trace file, add a descriptive comment to the select as previously posted.
If it means something else, then you need to explain to us what it is supposed to do.
Then we need to know what it is supposed to do for you.
Again, if it is just a comment in a statement to track it in a trace file, add a descriptive comment to the select as previously posted.
If it means something else, then you need to explain to us what it is supposed to do.
My guess is this is related question when you are trying to trace a SQL statement and are looking to add a comment to it so you can find it in the trace file.
Personally I would add a more descriptive comment other than the event number I am tracing.