SQL Versions

General

Access SQL will be written in CamelCase, while Oracle SQL will be uppercase.

AS / Table Alias

Access

SELECT Book.Isbn
  FROM tblBook AS Book

Oracle

The keyword AS is omitted, the alias for a table is put directly after the table name, separated by space.

SELECT BOOK.ISBN
  FROM BOOK BOOK

UPDATE

Access

    UPDATE tblStock     AS Stock
INNER JOIN tblBook      AS Book 
        ON Stock.ItemId  = Book.Id          
       SET Stock.Id      = Book.Isbn

Oracle

UPDATE STOCK            
   SET ID      = ( SELECT ISBN FROM BOOK WHERE STOCK.ITEMID = BOOK.ID )
 WHERE    EXISTS ( SELECT ISBN FROM BOOK WHERE STOCK.ITEMID = BOOK.ID )