How to create a table in oracle database administration using sql plus

Like i said in earlier post oracle database is relational database with markup and extensive language (xml). Data is stored in two dimensional tables consisting of rows and columns. oracle database enables you to store, update and efficiently retrieve it with high degree of performance and reliability.
Every thing is tables. having a database means having a pools of tables containing information that are related. Linked together keys and constraints, like foreign keys and primary keys.


To get started open your sql plus and enter your log in username and password.
You will notice that my password isn't showing as i typed it. that for security purposes.

 Before you start creating a table, you need to know the kind of table you want to create and the attributes of the table. By attributes I mean what will make up the columns of the table.

Lets take for instance creating a  employee table or rather let me say 'staff' because i already have a table called employee in my database. So staff table will consist of name, staff id, phone number, hire date, salary, department etc.

Having put these down. we head down to assigning the data types to each attribute.

Attributes	datatype	size
staff ID	varchar2	7
First name	varchar	20
Last name	varchar	20
address	varchar2	100
phone number	number	11
email	varchar2	20
depatment ID	varchar	5
Manager ID	number	7
Salary	number	9

 

You will notice i skipped some part. Yes but it makes no difference. you can do other examples on your own and include them. just follow the procedure.