Home >> Oracle >> Create table in Oracle

Create table in Oracle

Create table used for create new table in a database.

Syntax

create table tablename(

    columnname1 datatype,
    columnname2 datatype,
    columnname3 datatype,
   ....
   columnnamen datatype,

)

Example

CREATE TABLE students  
( student_id number(11) NOT NULL,  
  student_name varchar(50) NOT NULL,  
  class_name varchar(50)  
);  

 

Post Your Comment

Next Questions
Drop table
Truncate table
Alter Table
Create table AS
Global Temporary tables
SELECT Query
INSERT Query
INSERT ALL Query
UPDATE Query
DELETE Query
WHERE clause
AND Clause
OR Clause
LIKE clause
IN clause
ORDER BY Clause
GROUP BY Clause
HAVING Clause
BETWEEN
EXISTS
NOT EXITS
ANY
ALL
MAX
MIN

Copyright ©2022 coderraj.com. All Rights Reserved.