在Oracle中创建多个表 [英] Creating Multiple table in Oracle

问题描述

我正在使用Oracle Express 10g，并在sql命令行中输入以下文本来创建2个表，但是它不起作用.

I am using Oracle Express 10g and I'm enter the following text to create 2 tables in the sql command line, but it is not working.

CREATE TABLE student (
    matric_no     VARCHAR2(8),
    first_name    VARCHAR2(20),
    last_name     VARCHAR2(20),
    date_of_birth DATE
);

CREATE TABLE student1 (
    matric_no     VARCHAR2(8),
    first_name    VARCHAR2(20),
    last_name     VARCHAR2(20),
    date_of_birth DATE
);

谁能看到我在做什么错

谢谢

推荐答案

通过命令行"，您可能表示Oracle Express 10g随附的Web应用程序.此应用程序具有多个浏览器不兼容功能，并且基本上无法一次执行多个语句(另请参见

By "command line" you probably mean the web application that comes with Oracle Express 10g. This application has several browser incompatibilities and is basically unable to execute several statements at once (also see Oracle 10g - invalid character on DB importing).

将您的语句放在一个文本文件中，然后将它们作为SQL脚本上载.或切换到更好的工具，例如SQL Developer(可从Oracle网站下载).

Either put your statements in a text file and upload them as a SQL script. Or switch to a better tool such as SQL Developer (downloadble from Oracle web site).

这篇关于在Oracle中创建多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！