CREATE TABLE Country ( ID SMALLINT UNSIGNED AUTO INCREMENT, ISOCode 2 CHAR ( 2 ) NOT NULL, CountryName VARCHAR ( 1 5 ) , PRIMARY KEY ( ID ) ) INSERT INTO Country ( ID , ISOCode 2 , CountryName ) VALUES ( 4 9 , ' LS ' , NULL )

Question

CREATE TABLE Country ( ID SMALLINT UNSIGNED AUTO   INCREMENT, ISOCode 2 CHAR ( 2 ) NOT NULL, CountryName VARCHAR ( 1 5 ) , PRIMARY KEY ( ID ) )  INSERT INTO Country ( ID , ISOCode 2 , CountryName ) VALUES ( 4 9 , ' LS ' , NULL )

Accepted Answer

The Answer is in the image, click to view ...

Question

CREATE TABLE Country ( ID SMALLINT UNSIGNED AUTO _ INCREMENT, ISOCode 2 CHAR ( 2 ) NOT NULL, CountryName VARCHAR ( 1 5 ) ,

CREATE TABLE Country $($

ID SMALLINT UNSIGNED AUTO $_$ INCREMENT,

ISOCode $2$ CHAR $(2)$ NOT NULL,

CountryName VARCHAR $(15),$

PRIMARY KEY $($ ID $)$

$)$ ;INSERT INTO Country $($ ID $,$ ISOCode $2,$ CountryName $)$

VALUES $(49,'$ LS $',$ NULL $)$ ;

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Oracle 10g SQL