Oracle database Common keywords and notation

Database Common keywords:

CREATE TABLE --- Create a table

Create a table with table name (column name type of column, column name Type of column ... )

CREATE TABLE Z_course (ID number, Cour_code VARCHAR2 (), Cour_name VARCHAR2 (), p_cour_code VARCHAR2 ());

INSERT INTO---inserting data

Insert data table name (table's column type)

The value to be inserted (data that conforms to the type of the column, several columns are written, and the type of the column is to be met)

INSERT into Z_course (ID, Cour_code, cour_name, P_cour_code)

values (1, ' LAU-100 ', ' Major in Chinese language and literature ', null);

Delete---Remove data

Delete Table name restrictions when conditions why, data is deleted from the table

Delete emp e where e.empname= ' jjj ';

Update---Updates a single piece of data

Change table Name set a property Why do data changes to a table when the condition is?

Update emp e set e.empname= ' QQQQ ' where e.id=4;

Select---query data (in the actual work do not write *,* represent all, for the larger the data will affect the speed of operation, you can give the table plus variable name, represented by a letter, and then the letter. You can get the columns that need to be displayed in the table, and multiple columns can be separated by commas.

Query all Columns (*) from table name

SELECT * from Z_student;

Query a column of names within a table

Select S.name from Z_student s;

WHERE---impose a constraint on the executed statement

Set---certain properties

Oracle database Common keywords and notation