错误"SQL语句EDIT中超出最大字符数:问题显示表" [英] Error "Maximum Characters Exceeded in SQL Statement EDIT: Issue Displaying Table

问题描述

感谢您的帮助.我是SQL编程的新手(例如，这是我的第一份工作)，我完全不明白为什么它不起作用. 我的目标只是使它成为一个简单的表.我被要求使用来自sqlcourse.com的SWL解释器，当我将其放入程序时，出现错误"SQL语句中超出了最大字符数".每次检查语句时，我都会漏掉错误所在的位置.请帮忙吗?

Thank you for helping. I am brand new to SQL programming (as in, this is my first assignment) and I completely don't understand why this is not working. My goal is just to make this into a simple table. I was asked to use the SWL interpreter from sqlcourse.com, and when I put in the program I get the error "Maximum characters exceeded in SQL statement." Each time I check my statement I'm missing where the error is. Help please?

我的声明:

create table Marchetta1
(CustomerNum number(15), CustomerName char(15), 
 Street varchar(15), City char(15), 
 State char(2), Zip number(5), Balance number (8,2), 
 CreditLimit number (8,2), RepNum varchar (5));

insert into Marchetta1
(CustomerNum, CustomerName, Street, City, 
State, Zip, Balance, CreditLimit, RepNum) 
values ('123', 'Bob Smith', '8215 Cherry St', 'Grove', 'FL', '33331', '500.23', '1000', 'FP123');

insert into Marchetta1 (CustomerNum, CustomerName, Street, 
City, State, Zip, Balance, CreditLimit, RepNum) 
values ('456', 'Lucy James', '4711 Ohio St', 'Chicago', 'IL', '60644', 
'7000.44', '5000.80', 'FP123');

insert into Marchetta1 (CustomerNum, CustomerName, Street, 
City, State, Zip, Balance, CreditLimit, RepNum) 
values ('789', 'John Jones', '925 Main St', 'Grove', 'FL', '33385', '87.50', '2000.72', 'FP123');

修复程序似乎可以正常运行，并且命令已执行...但是由于我的表未显示，因此我无法检查.我该怎么办?

The fixes seemed to work and the commands are executed...but I have no way to check since my table is not displaying. How do I do that?

谢谢.

推荐答案

"SQL语句中超出了最大字符数."

"Maximum characters exceeded in SQL statement."

就是这个问题.您的SQL语句太长.

That's the problem. Your SQL statement is too long.

您所拥有的有四个不同的SQL语句.您应该一个一个地输入它们.

What you have there are four different SQL statements. You should be entering them one-by-one.

这篇关于错误"SQL语句EDIT中超出最大字符数:问题显示表"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！