Home » SQL & PL/SQL » SQL & PL/SQL » SQL Operators - Datatypes allowed (Oracle 9i)
SQL Operators - Datatypes allowed [message #401167] Fri, 01 May 2009 22:09 Go to next message
ygsunilkumar
Messages: 100
Registered: August 2008
Senior Member
Please provide the Datatypes allowed for the each below mentioned operators. Thanks

=
<>
>
>=
<
<=
BETWEEN
IN
LIKE
IS NULL
AND
OR
NOT

Re: SQL Operators - Datatypes allowed [message #401168 is a reply to message #401167] Fri, 01 May 2009 22:21 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Your answer is just a few clicks beyond the URL below.
http://tahiti.oracle.com
Let us know when you have found your answer.

[Updated on: Fri, 01 May 2009 22:28]

Report message to a moderator

Re: SQL Operators - Datatypes allowed [message #401172 is a reply to message #401168] Fri, 01 May 2009 23:23 Go to previous messageGo to next message
ygsunilkumar
Messages: 100
Registered: August 2008
Senior Member
No I didnot find any answer in the provided link. Please help.
Re: SQL Operators - Datatypes allowed [message #401173 is a reply to message #401167] Fri, 01 May 2009 23:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
I assure you that DATATYPES are completely documented.

Do you require remedial SEARCH training?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref19
Re: SQL Operators - Datatypes allowed [message #401187 is a reply to message #401167] Sat, 02 May 2009 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference
Chapter 2 Basic Elements of Oracle SQL
Section Datatype Comparison Rules

Regards
Michel
Re: SQL Operators - Datatypes allowed [message #401244 is a reply to message #401167] Sun, 03 May 2009 03:28 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Dates. Only dates are allowed. (Of course you could choose to disprove me on this..., now, how would you go about doing that?)
Previous Topic: Stored Procedure using dbms_random.value
Next Topic: tuning or refining query
Goto Forum:
  


Current Time: Sat Dec 10 18:53:23 CST 2016

Total time taken to generate the page: 0.24380 seconds