Random Titbits for Migrating from MySQL to Oracle

In MySQL the recommended way of showing all tables in a database is to use:

SHOW TABLES;

, but in Oracle you should use:

SELECT TABLE_NAME FROM TABS;

In MySQL SQL the comment style is to use the hash (#) character at the start of each line to be commented, or a line starting with ”– ” or '/*' followed by '*/' for multi-line comments, e.g.,

# This IS a single line comment
-- This is also a single line comment
/* This
   is
   a 
   multi-line
   comment */

In Oracle the recommended method for creating comments should be that the line of comment starts with '–' for single line comment or '/*' followed by '*/' for multi-line comments, e.g.,

-- This is a single line comment
/* This
   is
   a 
   multi-line
   comment */