Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Escaping ampersand (&) in queries

51564Jan 23 2007 — edited Oct 11 2007
How do I escape an ampersand in a query executed in the SQL Worksheet in SQL Developer? For example if my query is:

SELECT * FROM EMPLOYEES WHERE status = 'Hired &Fired';

If I execute this query now in SQLD, it asks me to enter a parameter for &Fired, whereas in this case, ampersand is a value in the column status in this table.

Thanks for all the help,
Alex

Comments

Zoltan Kecskemethy
If you have JAVA_HOME or other Java related environment variables set try to unset them for the installation.
The installer uses its own Java from the installer package.
450804
Hi,

for me it is not easy to say what went wrong. What is clear ist that something with the environment is not ok. With oraToolKit however you get a clean environment which will certainly work. Visit:

http://www.oratoolkit.ch/knowledge/otn.php

to see some how-tos for RHEL 5.

Cheers,
David

OCP 9i
http://www.oratoolkit.ch/otn.php
737797
I have solve this by issued "xhost + " command used root user.
I don't understand why it have any relation with that!

Thanks to everyone!
1 person found this helpful
749010
I am getting the same exception. I tried using xhost_+ but it's still not working for me.
Again, here is the error that I'm receiving when trying to install Oracle 11g:

Exception in thread "main" java.lang.NoClassDefFoundError
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at java.awt.Toolkit$2.run(Toolkit.java:821)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
at com.jgoodies.looks.LookUtils.isLowResolution(Unknown Source)
at com.jgoodies.looks.LookUtils.<clinit>(Unknown Source)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:122)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1783)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:480)
at oracle.install.commons.util.Application.startup(Application.java:758)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)

Thanks in advance for the help!!
Also, this is all very new to me. So if you could provide a step-by-step answer I would really appreciate it.

Edited by: user9014123 on Jan 25, 2010 1:40 PM
450804
Hi,

for a step by step answer try this:

http://www.oratoolkit.ch/knowledge/howto/installation/otn.php

Cheers,
David

OCP 9i / 10g / 11g
749010
This worked for me. Hope it helps others as well:
Open a new terminal, change the user to Oracle

Open an xterm session
xterm
Disable the access control using
xhost _+
check if this works
xclock
If it does, you are ready to run the installer.
./runInstaller
Aris Prassinos
See if this helps.

http://arisprassinos.blogspot.com/2010/05/noclassdeffounderror-during-silent.html
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 8 2007
Added on Jan 23 2007
#sql-developer
14 comments
303,276 views