crystalhelp
Programmer
I feel so stupid that I can't figure this out. I am writing a script that creates several tables. Essentially it starts out as:
create table x(
a number,
b number);
create table y(
c number,
d number);
create table z(
e number,
f number);
begin
--my variable declaration
-- a bunch of insert statements etc.
end;
I keep getting the error ORA-00911 Invalid Character. It won't tell me where the invalid character is. If I run each of the create table statements alone, it works, but when I select all of the create table statements together and run them I get the error.
What is the syntax you use between each create statement?
create table x(
a number,
b number);
create table y(
c number,
d number);
create table z(
e number,
f number);
begin
--my variable declaration
-- a bunch of insert statements etc.
end;
I keep getting the error ORA-00911 Invalid Character. It won't tell me where the invalid character is. If I run each of the create table statements alone, it works, but when I select all of the create table statements together and run them I get the error.
What is the syntax you use between each create statement?