Oracle Basic Syntax

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.