Is the syntax of Oracle10g and mysql are the same? For example the select query? Thanks, I'm using MySQL and want to try Oracle 10g for my java.
Mysql – Is the syntax of Oracle 10g and MySQL the same
MySQLoracle-10g
Related Question
- Oracle: No more data to read from socket
- Oracle 10g express database link to Oracle 8i
- Map user in oracle 10g
- Oracle 10g – How to Resize Tablespace
- Oracle 10g – Find Last Populated Date of Table
- oracle-10g – Recursive Manager in Oracle 10g vs 11g
- Mysql – Migrating from Oracle to MySQL via MySQL workbench: Table list is empty
Best Answer
They're vastly different when it comes to other features, such as security, programming languages, data types, tools, end user support, requirements, etc.
However, they're both compliant with basic SQL92 (and perhaps other SQL standards), so one can do the same basic schema creation and data querying and manipulation. You should be able to do the basics from java applications without noticing where you're connected to (and this applies to several other databases).