开发者

Error in Table Creation Statement

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜