CODEWITHSUNDEEP
sqloracle-databasesqlplus
Crimpy
Crimpy

Reputation: 195

SQL "batch file" issue with single quote

I'm writing a SQL batch script file and for some reason, I'm getting some strange characters for the single quote

'

Here is an example of what I wrote:

 DESC Cost_table;
 INSERT INTO Cost_table VALUES (‘US Mail’,2,20,25,20,2);
 INSERT INTO Cost_table VALUES (‘Fly By Night’,10,100,150,5,10);

The result in the code when it runs, looks like this:

SQL Output when I run the script

Anyone know how to fix this? Any help would be greatly appreciated.

Upvotes: 0

Views: 236

Answers (1)

Robby Cornelissen
Robby Cornelissen

Reputation: 97237

Those are not single quotes that I see in your queries. Change

DESC Cost_table;
INSERT INTO Cost_table VALUES (‘US Mail’,2,20,25,20,2);
INSERT INTO Cost_table VALUES (‘Fly By Night’,10,100,150,5,10);

to

DESC Cost_table;
INSERT INTO Cost_table VALUES ('US Mail',2,20,25,20,2);
INSERT INTO Cost_table VALUES ('Fly By Night',10,100,150,5,10);

This wikipedia article provides information about the different types of quotation marks. The ones you are using are referred to as slanted/curved quotes.

Upvotes: 3

Related Questions