Database creation, adding and deleting fields, creating forms, filtering (personal notes) not detailed, field forms
Login Name: SYS password: 123456 Database: SESYSBDA2. you are not authorized to log on to the system. assign permissions 4. login 5. change Password 6. delete a user 7. create Table create grant permission alter modify identified deformation Delete drop attribute username (delete) revoleke remove constraint delete column (s) field query languageSQL Structured query Language cascade cascading creation user create user bd01 identified by 123456 permission grant connect, resource, dba to bd01 administrator to remove permission revoke dba (attribute) from username Delete table create user a001 identified by 123456; grant permissions connect, resource, dba to a001; Change Password alter user a001 identified by 111111; remove permissions revoke resource from a001; delete drop user a001; create table Name (field data type (Data Length ), field data type (Data Length) add field alter table name add field data type (Data Length) constraint field alter table name add constraint pk_id primary key (field) primary key constraint alter table name check constraint alter table name add constraint ck_age check (age> = 20) filter: Data Definition Language (DDL) create alter dropH *** data manipulation language DML add, delete, modify, query *** transaction control language TCL Data Control Language DCL grant DML add insert .. (field) values .. (data corresponding to the Field) delete form modify update set find selsect fromTCL * commit change data is committed using transactions svaepoint * rollbackDCL ------------------------------ add *** insert into Table Name (Added field, added field) values (added value, added value); --- specify column --- virtual table dual prepare data insert into Table Name (attribute, attribute) --- corresponding to select 6003, 'Volume two awards 'form dual; --- insert into empl (nums, ename, sxe, age, salary) select 010, '王', 30000, from dual; commit; cmmit; ----- after changing the data, *** insert into table name values (added value, added value ,...); --- a whole column