开发者

Error in Table Creation Statement

开发者 https://www.devze.com 2023-01-27 18:24 出处:网络
code: create table Penalties ( PaymentNo number (4) not null, PlayerNo number(4), Pen_date date default now(),

code:

create table Penalties (
  PaymentNo number (4) not null, 
  PlayerNo number(4),
  Pen_date date default now(), 
  Amount number(7,2) default 2000.00
);

Error information (in German):

Fehler beim Start in Zeile 1 in Befehl:
create table Penalties (PaymentNo number (4) not null, PlayerNo number(4),Pen_date date default now(), Amount number(7,2) default 2000.00)
Fehler bei Befehlszeile:1 Spalte:96
Fehlerbericht:
SQL-Fehler: ORA-04044: Prozedur, Funktion, Package oder Typ hier nicht zulässig
04044. 00000 -  "procedure, function, package, or type is not allowed here"
*Cause:    A procedure开发者_StackOverflow社区, function, or package was specified in an
           inappropriate place in a statement.
*Action:   Make sure the name is correct or remove it.

Please help


Using now() as default value is not allowed here. Try replacing it with sysdate


Change default now() to default sysdate

0

精彩评论

暂无评论...
验证码 换一张
取 消