尚硅谷_宋红康_01_基本SQL-SELECT语句幻灯片.pptVIP

Selecting Specific Columns of All Rows You can use the SELECT statement to display specific columns of the table by specifying the column names, separated by commas. The example on the slide displays all the department numbers and location numbers from the DEPARTMENTS table. In the SELECT clause, specify the columns that you want, in the order in which you want them to appear in the output. For example, to display location before department number going from left to right, you use the following statement: SELECT location_id, department_id FROM departments; Instructor Note You can also select from pseudocolumns. A pseudocolumn behaves like a table column but is not actually stored in the table. You cannot insert or delete values of the pseudocolumns. Some available pseudocolumns are CURRVAL, NEXTVAL, LEVEL, ROWID, and ROWNUM. … Writing SQL Statements Using the following simple rules and guidelines, you can construct valid statements that are both easy to read and easy to edit: ? SQL statements are not case sensitive, unless indicated. SQL statements can be entered on one or many lines. ? Keywords cannot be split across lines or abbreviated. Clauses are usually placed on separate lines for readability and ease of editing. ? Indents should be used to make code more readable. Keywords typically are entered in uppercase; all other words, such as table names and columns, are entered in lowercase. Executing SQL Statements Using iSQL*Plus, click the Execute button to run the command or commands in the editing window. Instructor Note Although not required in iSQL*Plus, placing a semicolon (;) at the end of the last clause is recommended. Other environments, such as PL/SQL programs, require that the end of each statement contains a semicolon. Arithmetic Expressions You may need to modify the way in which data is displayed, perform calculations, or look at what-if scenarios. These are all possible using arithmetic expressions. An arithmetic expression can