Oracle table creation and addition, deletion, modification, and operation commands

Common addition, deletion, and modification operations for creating data tables and data tables

1. Click "Start/Program/Oracle-orahome92/Application Development/SQL plus ";

2. In "user name [u]:" and "password [p]:" Enter the user name and password of system. The default value is system and Manager (or the password set during installation)

3. Create a tablespace "test" with a size of 100 m:

Create tablespace "test ";
Logging;
Datafile 'd:/Oracle/oradata/test/Haig. ora 'size 100 m;

4. create user "test", default tablespace "test ";

Create user "test" Profile "default" identified by "test ";
Default;
Tablespace "test" account unlock;

5. Grant three permissions: unlimited tablespace, connect, resource;

Grant unlimited tablespace, connect, resource to "test ";

6. Log On with the "test" user;

Connect test/test;

1. Create a table;

Create Table count
(
Num1 number (4, 2 ),
Num2 number (5, 2 ),
Result number (6, 2)
);

2. Insert data;

Insert into count (num1, num2, result) values (1, 1, 2 );
Insert into count (num1, num2, result) values (1, 1 );
Insert into count (num1, num2, result) values (2, 8, 10 );
Insert into count (num1, num2, result) values (158 );

3. submit data;

Commit;
4. update data;

Updated count set num1 = 100;
5. delete data;

Delete from count;
6. query data;

Select * From count;