Solved

sql request

Posted on 2014-04-29
7
260 Views
Last Modified: 2014-05-20
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.
0
Comment
Question by:vangogpeter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 4

Accepted Solution

by:
Alex Matzinger earned 500 total points
ID: 40030840
Not sure what you're asking for...

if thats a comment:

select /* 10046 */ *
from emp;

Open in new window


if you're asking for all values like 10046?

select *
from emp
where value like ('%10046%');

Open in new window

0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030851
I believe Alex has the correct syntax in his first code example.

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.
0
 

Author Comment

by:vangogpeter
ID: 40030859
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.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030861
>>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?
0
 
LVL 4

Expert Comment

by:Alex Matzinger
ID: 40030866
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"; 

Open in new window

0
 

Author Comment

by:vangogpeter
ID: 40030870
No it is printed out no link.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030904
>>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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question