blocks|key|886286|text|两者之间在功能或性能上没有区别。使用您喜欢的任何语法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886287|这就像在声明函数或过程时使用AS和IS一样。它们是完全可互换的。|886288|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

There is no functional or performance difference between the two. Use whichever syntax appeals to you.

It's just like the use of AS and IS when declaring a function or procedure. They are completely interchangeable.

blocks|key|1101175|text|它们是相同的(第三种形式是%5E=)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1101176|但是请注意，从解析器的角度来看，它们仍然被认为是不同的，即为!=定义的存储大纲与<>或%5E=不匹配。|1101177|这与PostgreSQL不同，在This中，解析器仍在解析阶段处理!=和<>，因此不能将!=和<>重载为不同的运算符。|1101178|entityMap^0|D|2|0|U|2|14|2|17|2|0|2|A|X|2|10|2|18|2|1B|2|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]|$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|K|$]]

They are the same (as is the third form, <code>^=</code>).

Note, though, that they are still considered different from the point of view of the parser, that is a stored outline defined for a <code>!=</code> won't match <code>&lt;&gt;</code> or <code>^=</code>.

This is unlike <code>PostgreSQL</code> where the parser treats <code>!=</code> and <code>&lt;&gt;</code> yet on parsing stage, so you cannot overload <code>!=</code> and <code>&lt;&gt;</code> to be different operators.

blocks|key|1101225|text|它们是一样的，但我听人说开发人员使用!=，而BA使用<>|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1101226|entityMap^0|I|2|Q|2|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

They are the same, but i've heard people say that Developers use <code>!=</code> while BA's use <code>&lt;&gt;</code>

blocks|key|1101278|text|正如其他人所说，没有什么不同。(作为一个健全的检查，我做了一些测试，但这是浪费时间，它们当然是一样的。)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101279|但实际上有四种类型的不等式运算符：!=、%5E=、<>和¬=。参见this+page+in+the+Oracle+SQL+reference。在网站上，第四个运算符显示为ÿ=，但在PDF中显示为¬=。根据文档，其中一些在某些平台上不可用。这实际上意味着¬=几乎永远不会工作。|offset|length|1101280|出于好奇，我真的很想知道¬=在什么环境下工作。|1101281|entityMap|0|LINK|mutability|MUTABLE|url|http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/conditions002.htm#i1033286^0|0|V|11|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

As everybody else has said, there is no difference. (As a sanity check I did some tests, but it was a waste of time, of course they work the same.)

But there are actually FOUR types of inequality operators: !=, ^=, &lt;>, and ¬=. See <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/conditions002.htm#i1033286" rel="nofollow">this page in the Oracle SQL reference</a>. On the website the fourth operator shows up as ÿ= but in the PDF it shows as ¬=. According to the documentation some of them are unavailable on some platforms. Which really means that ¬= almost never works.

Just out of curiosity, I'd really like to know what environment ¬= works on.

blocks|key|1101331|text|使用类mybatis框架的开发人员会更喜欢!=而不是<>。原因是<>需要包装在CDATA中，因为它可以被解释为XML语法。对眼睛来说也更容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101332|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Developers using a mybatis-like framework will prefer != over &lt;>. Reason being the &lt;> will need to be wrapped in CDATA as it could be interpreted as xml syntax. Easier on the eyes too.

blocks|key|886577|text|区别在于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886578|“如果使用!=，则返回亚秒级。如果使用<>，则需要7秒才能返回。两者都返回正确的答案。”|offset|length|style|CODE|886579|Oracle+not+equals+(!=)+SQL+operator|886580|问候|886581|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dba-oracle.com/t_not_equal_operator.htm^0|0|5|2|J|2|0|0|Z|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]|$D|X|E|Y|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

The difference is :

"If you use <code>!=</code>, it returns sub-second. If you use <code>&lt;&gt;</code>, it takes 7 seconds to return. Both return the right answer."

<a href="http://www.dba-oracle.com/t_not_equal_operator.htm" rel="nofollow">Oracle not equals (!=) SQL operator</a>

Regards

There are two not equals operator - <code>!=</code> and <code>&lt;&gt;</code>. 

What's the difference between them? I heard that <code>!=</code> is more efficient than other for comparing strings. Could anyone give a qualitative comment on this statement.

Oracle Not Equals Operator

PostgreSQL

有两个不等于运算符- !=和<>。它们之间的区别是什么？我听说!=在比较字符串方面比其他的更有效。有没有人能对这一说法给出定性的评论。

问Oracle Not Equals运算符
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle Not Equals运算符EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle Not Equals运算符
EN