Little differences between Oracle and MSSQL

xiaoxiao2021-03-06  40

I have used MSSQL for a while, now I am learning Oracle.

Perform a very simple statement:

Update a

Set a.name = B.Name

From a join b on A.Id = B.ID

An error occurred;

Later, the Update syntax in Oracle found that Update in Oracle is an option without from.

This is my little mistake to study Oracle, this is also learned after MSSQL, with Oracle

The mistakes of learners often have to share with people I am in a stage!

转载请注明原文地址:https://www.9cbs.com/read-86024.html

New Post(0)