Skip to main content

RDBMS Data Definition Language | Create Buses table

 efer the below schema and create the buses table.

Column Name

Datatype

Size

Constraint

Constraint name

Bus_no

Number

11

Primary key

PK_BUSES

Bus_name

Varchar2

20


 

Type

Varchar2

20


 

Total_seats

Number

11


 

Avail_seats

Number

11


 


efer the below schema and create the buses table.  Column Name  Datatype  Size  Constraint  Constraint name  Bus_no  Number  11  Primary key  PK_BUSES  Bus_name  Varchar2  20      Type  Varchar2  20      Total_seats  Number  11      Avail_seats  Number  11

 
Result Description  Summary of tests +------------------------------+ | 3 tests run / 3 test passed  | +------------------------------+

 

Result Description

Summary of tests
+------------------------------+
| 3 tests run / 3 test passed  |
+------------------------------+
 


Comments

Subscribe to Get's Answer by Email