Shulou(Shulou.com)05/31 Report--

This article will explain in detail what the sql sentences are, and the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

In Sqlplus running cmd in Windows

Set the length of data displayed for each row:

Set linesize digit

Set the number of rows of data to display per page:

Set pagesinze digit

Switch users in oralce:

Conn username / password {as sysdba}, when using sys users, you must add the content in parentheses.

Query statement

Select statement.

Query all the table information below a user

Select table_name fomr user_tbales

Wildcard query:

*, the asterisk means all

Query the database table structure for specific columns:

Select * from table

Select field name, field name... From table

It is important to note that:

① letters are not case sensitive

On ② sql platforms, all statements must end with a semicolon

③ symbols are not allowed to be full-width symbols.

Query statement with operation symbol:

For example:

Select gongzi+100,name from table

Operation symbol +-* /

How to query the table structure:

Name of the Desc table

Query statement with column alias

Select field as column alias, … From table

Filter (conditional) query:

Select query content from table where condition

Compare operation symbols:

=

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.