SQL syntax and sqlplus

Source: Internet
Author: User

SQL statements reflect the language habits of English. For example, when we use select to query "Select fields from table", we first enter the field name and then the table name. This is in line with the English habit, that is, the first small location, then the Earth Point. If you use Chinese language habits to describe it, it should be "Fetch field from table: Select Table get fields ". So what are the advantages of adopting Chinese habits? Think about it first, hey!

I recently used oracel10g sqlplus, which is very uncomfortable. Fortunately, El has tens of billions of dollars. This product has been around for decades, but a sqlplus is still so primitive. I hope that the first function of sqlplus is the command history function. The preceding SQL commands can be repeated by arrows. I hope that the second feature of sqlplus is the automatic completion of commands. So I thought of the SQL syntax mentioned above. If the SQL statement is such a "Select Table get fields", after the SELECT statement is input, the SMART system should be able to automatically list all the current table names, the field name is automatically displayed after the table name is entered.

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.