Create table with three columns : Create Table « Table « Oracle PL / SQL






Create table with three columns

   


SQL> CREATE TABLE customers
  2  (
  3     id                NUMBER,
  4     credit_limit      NUMBER,
  5     email             VARCHAR2(30)
  6  );

Table created.

SQL>
SQL>
SQL> select id, credit_limit
  2  from   customers
  3  where  id = 28983;

no rows selected

SQL>
SQL> drop table customers;

Table dropped.

SQL>
SQL>

   
    
    
  








Related examples in the same category

1.Create table template
2.Create table with data type: VARCHAR2, Date, Number(8,2)
3.Using a CREATE TABLE statement: create a table with primary key
4.Creating Table with combined primary key
5.Create table with foreign key
6.Creating an index-organized table
7.create as select
8.create as select, then add primary key
9.CREATE TABLE AS SELECT with where clause
10.Creating Table and indicate tablespace
11.An example of creating an index-organized table:
12.Create a table with 'deferrable initially immediate'
13.include a complete CREATE INDEX clause as part of the CREATE TABLE statement
14.Create a table by specifying the storage settings
15.Create a table with ORGANIZATION INDEX
16.Use 'using index' option when creating a table
17.Create a table and set storage FREELISTS 2
18.Create a table with 'overflow INCLUDING y'
19.Create table with Check Constraints
20.Create table with Unique Constraints
21.Creating an External Table
22.A create-table statement with the attributes of ISBN, title, author, and publisher. The primary key is the ISBN attribute.
23.Create intermediate table for calculation
24.Create an external table