Difference between revisions of "SQL Versions"
Jump to navigation
Jump to search
(Created page with 'Category:Microsoft Access Category:Oracle Category:SQL === AS / Table Alias === ==== Access ==== <syntaxhighlight lang="sql"> SELECT Book.Isbn FROM tblBook AS Boo...') |
|||
| Line 2: | Line 2: | ||
[[Category:Oracle]] | [[Category:Oracle]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| + | |||
| + | === General === | ||
| + | Access SQL will be written in CamelCase, while Oracle SQL will be uppercase. | ||
=== AS / Table Alias === | === AS / Table Alias === | ||
| Line 12: | Line 15: | ||
==== Oracle ==== | ==== Oracle ==== | ||
| + | The keyword ''AS'' is omitted, the alias for a table is put directly after the | ||
| + | table name, separated by space. | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
SELECT BOOK.ISBN | SELECT BOOK.ISBN | ||
| − | FROM BOOK | + | FROM BOOK BOOK |
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 22: | Line 27: | ||
==== Access ==== | ==== Access ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | UPDATE | + | UPDATE tblStock AS Stock |
INNER JOIN tblBook AS Book | INNER JOIN tblBook AS Book | ||
| − | ON | + | ON Stock.ItemId = Book.Id |
| − | SET | + | SET Stock.Id = Book.Isbn |
</syntaxhighlight> | </syntaxhighlight> | ||
==== Oracle ==== | ==== Oracle ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | UPDATE | + | UPDATE STOCK |
| − | SET | + | SET ID = ( SELECT ISBN FROM BOOK WHERE STOCK.ITEMID = BOOK.ID ) |
| − | WHERE | + | WHERE EXISTS ( SELECT ISBN FROM BOOK WHERE STOCK.ITEMID = BOOK.ID ) |
</syntaxhighlight> | </syntaxhighlight> | ||
Latest revision as of 15:32, 7 April 2011
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 )