SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use date in apex oracle ?

Unkn0wn27Oct 3 2016 — edited Oct 4 2016

I am new at using apex.oracle and of course i stumbled across a problem i have no ideea what the problem is...

This is my code.

create table client(

cod integer primary key not null,

nume varchar2(25) null,

prenume varchar2(25) null,

patronimul varchar2(25) null,

oras varchar2(25) default('chisinau'),

sexul char(1) null,

data_nasterii date null,

telefon varchar2(25) null);

insert all

into client(cod, nume, prenume, patronimul, oras, sexul, data_nasterii, telefon) values(1,'Ivan','Ivanovici','Ivanescu','Chisinau','M','2014-11-22',068111111)

SELECT 1 FROM DUAL;

The error is : ORA-01843: not a valid month.

I tried everything to change it but it still shows me this error or

This error : ORA-00001: unique constraint (UNKNOWN.SYS_C0049683476) violated.

Please help!

This post has been answered by BluShadow on Oct 3 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2016

Added on Oct 3 2016

#apex, #sql

5 comments

452 views