Answered: whats this error and how could i fix it…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

i wants to insert sucha csv in a table into a sql developer table .

population.csv

Quebec (Que.),791.9,46.8273212, -71.2349247 Sherbrooke (Que.),210,45.4009928, -71.8824288 Trois Rivieres Quebec,155,46.3432397, -72.5432834 Montreal (Que.),"3981.80",45.491577, -73.64106699999999

----

so i create a table like this

Error starting at line : 2 in command -
CREATE TABLE populationtest (
place int AUTO_INCREMENT,
Population int DEFAULT 0,
lat decimal(6,2) default 0.00,
ion decimal(6,2) default 0.00
)
Error report -
ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:

whats this error and how could i fix it correct ?

A.
B
D
E
place
St. John's (I
Halifax (N.S
Ipopulation lat
lon
208.4 47.56054 -52.7128
408.7 44.64886 -63.5753
Moncton (I
144.9 46.10139 -64.8214
Saint John
127.9 45.27332 -66.0633

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions