error on some code that i wrote

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

error on some code that i wrote

Author

Topic

vitaly87
Starting Member

13 Posts

Posted - 2009-10-29 : 12:42:39

drop table students
create table students(id number(4),firstName varchar2(10),lastName varchar2(30),address varchar2(30),bithday date,groupid number(4))

alter session set nls_date_format='dd/mm/yyxx'

insert into students values(1000,'vitaly','men','beer sheva','20/03/1987',1000);

the error is
ORA-00933: SQL command not properly ended

i write without drop table students ,and it still write me an error.
thanks for the help.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-10-29 : 12:48:13

This is a MS SQL SERVER forum. Try http://www.dbforums.com/oracle/

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

vitaly87
Starting Member

13 Posts

Posted - 2009-10-29 : 12:57:25

thanks

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2009-10-29 : 20:40:02

I believe (don't quote me), but doesn't every SQL command in Oracle need to be terminated with a semi-colon?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources