Create Table Oracle Database Tutorial Example

How To Create Table In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to create table in Oracle Database Server Tutorial Example

-- connect as TUTORIAL
-- i am using sqlplus as client. you can use anything as you like.
 
   CREATE TABLE test
   (
     TestID NUMBER(10) default NULL,
     TestName varchar2(100) default NULL,
     TestAge NUMBER(10) default NULL
   );
      -- that's it!! Oracle database table "test" has been created with 3 columns
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Create Table In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Drop Table In Oracle Database Tutorial Example
  2. How To Truncate Table In Oracle Database Tutorial Example
  3. How To Insert Row In Oracle Database Table Tutorial Example
  4. How To Insert Specific Columns In Oracle Database Tutorial Example
  5. How To Select Data From Oracle Database Table Tutorial Example
  6. MySQL IFNULL() Function Number Example
  7. MySQL Stored Procedure Function: Making hello world Function using aliase Example
  8. MySQL Stored Procedure: Creating Table using Stored Procedure Example
  9. 19 Examples to Learn MySQL
  10. 20 Steps to Learn CakePHP by Example

2 comments:

  1. Thank you......please explain how one adds multiple rows to a table and is it possible to create more than one table in one execution/statement

    ReplyDelete
  2. The trade-off is that while relational databases are more powerful, they also require more time to master.
    oracle dashboards

    ReplyDelete

leave your comments here..