No there is no difference at all in functionality. &lt;br/&gt;
(The same is true for all other DBMS - most of them support both styles):

Here is the current SQL reference: https://docs.oracle.com/database/121/SQLRF/conditions002.htm#CJAGAABC

The SQL standard only defines a single operator for &quot;*not equals*&quot; and that is `&lt;&gt;`



Actually, there are **four** forms of this operator:

    &lt;&gt;
    !=
    ^=

and even

    &#172;= -- worked on some obscure platforms in the dark ages

which are the same, but treated differently when a verbatim match is required (stored outlines or cached queries).

At university we were taught &#39;best practice&#39; was to use != when working for employers, though all the operators above have the same functionality.

According to this article, != performs faster

http://www.dba-oracle.com/t_not_equal_operator.htm

I have an input field, where I try to make autocomplete suggestion. Code looks like

    &lt;input type=&quot;text&quot; id=&quot;myinput&quot;&gt;
    &lt;div id=&quot;myresults&quot;&gt;&lt;/div&gt;

On input&#39;s `blur()` event I want to hide results&#39; div:

    $(&quot;#myinput&quot;).live(&#39;blur&#39;,function(){
         $(&quot;#myresults&quot;).hide();
    });

When I write something into my input I send request to server and get json response, parse it into ul-&gt;li structure and put this ul to my `#myresults` div. 

When I click to this parsed li element I want to set value from li to input and hide `#myresults` div

    $(&quot;#myresults ul li&quot;).live(&#39;click&#39;,function(){
         $(&quot;#myinput&quot;).val($(this).html());
         $(&quot;#myresults&quot;).hide();
    });

Everything is going good, but when I click to my li `blur()` event fires before `click()` and input&#39;s value don&#39;t get li&#39;s html. 

How can I set up `click()` event before `blur()`?

jQuery: fire click() before blur() event

I have downloaded [node.js][1] executable. How can I run that executable as windows service?
I cannot use standard node.js installer, since I need to run multiple version of node.js concurrently.

  [1]: http://nodejs.org/

How to install node.js as windows service?

I would like to know if there are any differences in between the two `not equal` operators `&lt;&gt;` and `!=` in Oracle.

Are there cases where they can give different results or different performance?


Is there any difference between &quot;!=&quot; and &quot;&lt;&gt;&quot; in Oracle Sql?

<p>I would like to know if there are any differences in between the two <code>not equal</code> operators <code>&#x3C;></code> and <code>!=</code> in Oracle.</p>
<p>Are there cases where they can give different results or different performance?</p>


I am using SQL Server Management Studio. 

I wish to save the results of a query to an excel file.  

I choose &quot;save as&quot; and then save to CSV file which I can open in excel. All good except I am missing column headers, any ideas how I get them exported?

Saving results with headers in SQL Server Management Studio

I am new to SQL, and what I needed to do was to combine 2 .mdf databases into one. I did that using SQL Server 2008 Manager - Tasks &gt; Import/Export tables.The tables and views were copied successfully, but there are no Stored procedures in the new database. Is there any way to do that?

SQL Server - copy stored procedures from one db to another

I know how to log the SQL to log4net/NLog/trace window at runtime with the `show_sql` configuration option.

What I&#39;m looking for is a way to give a `Query&lt;T&gt;()` to NHibernate retrieve the generated SQL.

I&#39;ve looked through the Persister class, the Drivers, different Interceptors and Events. There are so many places to look, even narrowing down my search would be of great help.

How can I have NHibernate only generate the SQL without executing it?

How to change the column position of MySQL table without losing column data?

I have an existing table that I am about to blow away because I did not create it with the `ID` column set to be the table&#39;s Identity column.

Using **SQL Server Management Studio**, I scripted a *&quot;Create To...&quot;* of the existing table and got this:

    CREATE TABLE [dbo].[History](
	    [ID] [int] NOT NULL,
	    [RequestID] [int] NOT NULL,
	    [EmployeeID] [varchar](50) NOT NULL,
	    [DateStamp] [datetime] NOT NULL,
     CONSTRAINT [PK_History] PRIMARY KEY CLUSTERED 
    (
	    [ID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]


My question is, how would I modify this `SQL` so that my resulting table has the `ID` column set as the **Identity**?

How To Create Table with Identity Column

I&#39;m trying to insert `CLOB`s into a database (see [related question][1]). I can&#39;t quite figure out what&#39;s wrong. I have a list of about 85 clobs I want to insert into a table. Even when inserting only the first clob I get `ORA-00911: invalid character`. I can&#39;t figure out how to get the statement out of the `PreparedStatement` before it executes, so I can&#39;t be 100% certain that it&#39;s right, but if I got it right, then it should look exactly like this:

    insert all
      into domo_queries values (&#39;select 
    substr(to_char(max_data),1,4) as year,
    substr(to_char(max_data),5,6) as month,
    max_data
    from dss_fin_user.acq_dashboard_src_load_success
    where source = &#39;&#39;CHQ PeopleSoft FS&#39;&#39;&#39;)
    select * from dual;

Ultimately, this [`insert all`][2] statement would have a lot of `into`&#39;s, which is why I just don&#39;t do a regular `insert` statement. I don&#39;t see an invalid character in there, do you? (Oh, and that code above **runs fine when I run it in my sql developer tool**.) And I if I remove the semi-colon in the `PreparedStatement`, it throws an `ORA-00933: SQL command not properly ended` error.

In any case, here&#39;s my code for executing the query (and the values of the variables for the example above).

    public ResultSet executeQuery(String connection, String query, QueryParameter... params) throws DataException, SQLException {
      // query at this point = &quot;insert all
                              //into domo_queries values (?)
                              //select * from dual;&quot;
      Connection conn = ConnectionPool.getInstance().get(connection);
      PreparedStatement pstmt = conn.prepareStatement(query);
      for (int i = 1; i &lt;= params.length; i++) {
        QueryParameter param = params[i - 1];
        switch (param.getType()) { //The type in the example is QueryParameter.CLOB
          case QueryParameter.CLOB:
            Clob clob = CLOB.createTemporary(conn, false, oracle.sql.CLOB.DURATION_SESSION);
            clob.setString(i, &quot;&#39;&quot; + param.getValue() + &quot;&#39;&quot;);
            //the value of param.getValue() at this point is:
            /*
             * select 
             * substr(to_char(max_data),1,4) as year,
             * substr(to_char(max_data),5,6) as month,
             * max_data
             * from dss_fin_user.acq_dashboard_src_load_success
             * where source = &#39;&#39;CHQ PeopleSoft FS&#39;&#39;
             */
            pstmt.setClob(i, clob);
            break;
          case QueryParameter.STRING:
            pstmt.setString(i, &quot;&#39;&quot; + param.getValue() + &quot;&#39;&quot;);
            break;
        }
      }
      ResultSet rs = pstmt.executeQuery(); //Obviously, this is where the error is thrown
      conn.commit();
      ConnectionPool.getInstance().release(conn);
      return rs;
    }

Is there anything I&#39;m just missing big time?


  [1]: https://stackoverflow.com/questions/10727521/
  [2]: http://www.techonthenet.com/oracle/questions/insert_rows.php

Where&#39;s my invalid character (ORA-00911)

We have an application running locally where we&#39;re experiencing the following error:

&gt; ORA-12514: TNS:listener does not currently know of service requested
&gt; in connect descriptor

I&#39;ve tested the connection using `TNSPing` which resolved correctly and
I tried `SQLPlus` to try connecting, which failed with the same error as above. I used this syntax for `SQLPlus`:

    sqlplus username/password@addressname[or host name]

We have verified that:

- the TNS Listener on the server is running. 
- Oracle itself on the server is running. 

We don&#39;t know of any changes that were made to this environment. 
Anything else we can test?

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

    insert into OPT (email, campaign_id) values(&#39;mom@cox.net&#39;,100)
    where not exists( select * from OPT where (email =&quot;mom@cox.net&quot; and campaign_id =100)) ;

&gt; Error report: SQL Error: ORA-00933: SQL command not properly ended
&gt; 00933. 00000 -  &quot;SQL command not properly ended&quot;
&gt; *Cause:    
&gt; *Action:

how to insert a new row if it doesn&#39;t exists in Oracle?

Oracle insert if not exists statement

I want to insert to a table from a select statement, however, there are 3 columns returned from the select statement and the table has 4 columns, I would like to add 0 for all rows in the extra column. Can anyone give me a sample SQL query for that?

Thank you!

Oracle insert from select into table with more columns

Can anyone tell me how I can generate the DDL for all tables, views, indexes, packages, procedures, functions, triggers, types, sequences, synonyms, grants, etc. inside an Oracle schema? Ideally, I would like to copy the rows too but that is less important.

I want to do this on a scheduled job of some kind and not manually each time, so that rules out using the wizard in SQL Developer.

Ideally, since I will be running this on several schemas that have grants and synonyms to one another, I would like to have a way to do a find/replace in the output so the schema names match whatever the names of my new schemas are going to be.

Thanks!

Content Type	Original Author	Original Content on Stackoverflow
Question	Mesop	View Question on Stackoverflow
Solution 1 - Sql	a_horse_with_no_name	View Answer on Stackoverflow
Solution 2 - Sql	Quassnoi	View Answer on Stackoverflow
Solution 3 - Sql	user1403581	View Answer on Stackoverflow
Solution 4 - Sql	user5063308	View Answer on Stackoverflow

Is there any difference between "!=" and "<>" in Oracle Sql?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

How to install node.js as windows service?

jQuery: fire click() before blur() event

Attributions