re: sqlplus question

[hreddy007]

hi! ,

I have a file abc.sql
which has the following commands

drop table test
/
create table test(age number)
/

when I run the file from sqlplus using file -> open
I get the following error
SQL>
1 drop table test
2 /
3* create table test(age number)
SQL> /
/
*
ERROR at line 2:
ORA-00933: SQL command not properly ended


how do I rectify this error ?

thanks,
harish

[abhaysk]

drop table test;

create table test(age number);

Abhay.

[hreddy007]

SQL>
1 drop table test;
2* create table test(age number);
3 /
drop table test;
*
ERROR at line 1:
ORA-00911: invalid character

[akhadar]

say ur abc.sql contains

drop table test;
create table test (age number);

save the contents say it is in c:\test folder.Then go to SQL and type
SQL>@c:\test\abc.sql;