Database creation, adding and deleting fields, creating forms, filtering (personal notes) not detailed, field forms

Source: Internet
Author: User

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

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.