Plsql Operations Oracle Create users and tables

http://blog.csdn.net/doudou_demo/article/details/47666751

1, open Plsql, fill in the User name and password (the initial two user sys and system, the password is set by the Oracle database installation), database select ORCL (default database, Oracle created by the user is like MySQL built database, The two have the same wonderful

2, after the successful landing in the interface can see the head of the message, the top [email protected] is the user system in the login state, where the menu bar session can log in, exit

3, then find the user in the list below, then right--"new, create a new user, as shown in the following two images to set, and then click Apply on it." (Note: The three permissions in the diagram must be set, otherwise you will not be able to log in or can not manipulate the table error)


4, login to the new user, click on the previous session--log on, fill in the user name and password The third also choose ORCL, fourth Select the default normal, click Login

5, at the top can see the login status

6, create a database, right-click on the bottom left corner of the list of tables-new, create a fresh data table, fill in the name,comments is a note to the table, and then fill in the second picture of the required fields and their types, and finally click Apply Application,


7. To view the created table, click on the tables in the lower left-hand corner list, right-click on your new table, and edit the contents of the table by clicking on Edit Date.


The above is a new user in the Plsql, the steps to create a table, thank you!

Plsql Operations Oracle Create users and tables