Creating A Table using SQL Plus Oracle Part 3

Other SQL Plus commands and creating a table.

SQL> List;

This command will list the users.

To run some querys against SQL Plus, you can use the testing database call HR.

You first should alter the database by typing this:

SQL>ALTER USER HR IDENTIFIED BY greg ACCOUNT UNLOCK;

greg is the password.

You can select to see which tables belong to a particular owner by typing SQL>select table_name from sys.all_tables where owner='SCOTT';

Scott owns 4 tables called DEPT,EMP,BONUS,SALGRADE

You can create your own table by typing SQL>

CREATE TABLE employee (empid char(9) not null, name varchar(20), hiredate date);

(Part 4 coming soon)