Skip to Main Content

SQL & PL/SQL

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.

Using <> or != on a NULL

582145Nov 22 2007 — edited Dec 7 2007
Hi,

This is probably a very easy question..

When I try to SELECT some rows based on tableA.col1 <> tableB.col1, I get less rows than expected back. I think it's because some of the tableA.col1 are NULL and tableB.col2 have values.

Is there a way to check for equality w/out having to use IS NULL and IS NOT NULL?

Thanks,

Comments

Timo Hahn
Please post the URL you used to access the application...

Timo
Santosh M E
http://127.0.0.1:7101/RoutingTemplate-ViewController-context-root/faces/WEB-INF/Home.jspx?

thanks,
Santosh M E
Timo Hahn
The problem is the WEB-INF part in your URL. You can't access any resource inside the WEB-INF folder from the outside. Move your Home.jspx into the the webroot folder.
Next you should not have the suffix '.jspx' as part of your url. If you do you can't navigate as the adf bindings (and navigation) is not initialized.


Timo
Santosh M E
Thanks Timo.

It works :)
803319
Error 403--Forbidden





From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:

10.4.4 403 Forbidden

The server understood the request, but is refusing to fulfill it. Authorization will not help and the request SHOULD NOT be repeated. If the request method was not HEAD and the server wishes to make public why the request has not been fulfilled, it SHOULD describe the reason for the refusal in the entity. This status code is commonly used when the server does not wish to reveal exactly why the request has been refused, or when no other response is applicable.

While Uploading any file from my IE to Oracle SR.Any one help pn this


Regards

Raghu
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 4 2008
Added on Nov 22 2007
43 comments
7,037 views