Oracle Errors for queries

Vote count:

0

If I type a single statement like create table t( i int), then it displays table created. Again If i write drop table t, them it shows table dropped. So everything fine till now. Now the problem starts:- If i write both statements together like create table t(i int); drop table t;

again if write this drop table t; create table t( i int); it shows ORA-00911: invalid character

it shows this message -ORA-00922: missing or invalid option. cant we execute two queries simultaneously in oracle. I am using oracle 10 g through Database Home Page option.

asked 21 secs ago

Mohit

11

Oracle Errors for queries