How to Create a Table in Oracle SQL Plus Oracle 10G
In this post "How to Create a Table in Oracle SQL Plus Oracle 10G" we will learn how to create a table in Oracle SQL Plus. Before you create table in Sql Plus , you need to decide the name of the table and various columns names and data types of the columns.
Lets us take example of Student table , here you can decide name of the table as student and it could have columns as rollno, name, fees . Data type of rollno column could be either number or char , the data type of name column must be varchar2 type and datatype of fees column must be number.
The general syntax of create table in SQL SQL> create table <table name> ( column1 specification, column2 specification...);
The sql code to create above student table will be like this:
This way you can create any table in SQL.
Next: Desc Table Command
The general syntax of create table in SQL SQL> create table <table name> ( column1 specification, column2 specification...);
The sql code to create above student table will be like this:
SQL> create table student (rollno number(3), Name varchar2(20), fees Number(8,2));
This way you can create any table in SQL.
Next: Desc Table Command
