Used to log in to the Oracle database and execute SQL statements, using Sqlplus today do not know how to login, landing on the unexpectedly do not know how to view all the tables.
Login: sqlplus test/123456@192. 168.0. :1521/orcl
After landing want to see all the tables, using show tables; found not to use, so lamented the database vendor syntax is not unified good trouble, surf the internet a bit.
View all tables: Select * from User_tables;
Later think about it, not the database vendor does not unify the syntax, but the SQL syntax only specifies the INSERT, update, SELECT, delete syntax, it seems that there is no rule to show the table to use which statement, and I use MySQL habits, I think that is the standard, In fact, that is also MySQL's own set, compared to the MySQL show syntax, but Oracle's select better, from the fixed table query. But MySQL's show syntax is also a query from the table to do the encapsulation, but added a keyword show, but in the end what is good or bad? Hehe, only get the market is good, just like the ISO network model and TCP/IP, who has the market who is the winner.
The basic syntax for an Oracle database is documented below:
Oracle Basic Syntax