Essays /

Canadian Born Essay

Essay preview

Database Management System
Lab - 10

1. Create table CITIES from table LOCATIONS, but only for location numbers less than 2000 (do NOT create this table from scratch). You will have exactly 10 rows here. When you describe CITIES, the output is shown below:

SQL> DESC cities
Name Null? Type
----------------------------------------- -------- ----------------- LOCATION_ID NUMBER(4) STREET_ADDRESS ...

Read more


1 10 12 1500 2 2000 25 3 30 4 40 5 6 7 8 9 account address adr alias also base bin born call canada canadian char check citi code column command complex contain countri creat data databas definit depart desc describ dictionari differ display dname drop empti exact explain far follow happen id includ instead itali lab less locat manag modifi name null number one origin output p postal power prov provinc realli recycl remain remov restor row scratch select shown simpl sql state str street structur system tabl time town tri type varchar2 view vu well