https://sqlines.com/ 2026-04-14T11:19:39+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2013-10-30T12:38:47+00:00 https://sqlines.com/mysql-to-oracle/date_format?rev=1383136727&do=diff In MySQL, DATE_FORMAT function converts a DATE or DATETIME value to string using the specified format. In Oracle, you can use TO_CHAR function. Note that the DATE_FORMAT and TO_CHAR use different format strings. MySQL: -- Convert the current date to YYYYMM format SELECT DATE_FORMAT(NOW(), '%Y%m'); # 201302 text/html 2013-02-06T21:29:09+00:00 https://sqlines.com/mysql-to-oracle/drop_table_if_exists?rev=1360186149&do=diff In MySQL you can use IF EXISTS clause in the DROP TABLE statement. This is mostly uses to suppress error messages in the database schema creation scripts when they are executed for the first time. MySQL: -- The statement always returns success DROP TABLE IF EXISTS sales; text/html 2013-03-20T16:04:32+00:00 https://sqlines.com/mysql-to-oracle/insert?rev=1363795472&do=diff In MySQL, you can insert multiple rows using a single INSERT statement: MySQL: -- Sample table CREATE TABLE cities ( name VARCHAR(70), state CHAR(2) ); -- Insert multiple rows with single statement INSERT INTO cities (name, state) VALUES ('San Francisco', 'CA'), ('New York', 'NY'), ('Los Angeles', 'CA');