question

Sandra avatar image
Sandra asked

What is the INVALID CHARACTER error in the below Oracle Syntax?

What is the INVALID CHARACTER error in the below Oracle Syntax?

('00001', 'Perry', 'Cox', '555-1111', '555-1212');

testing
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thecoop avatar image thecoop ·
Whats the entire command you're trying to execute?
1 Like 1 ·
HillbillyToad avatar image HillbillyToad ·
This looks like a fun challenge! Oracle returns the line number and character position so this doesn't turn into a guessing game :)
0 Likes 0 ·
KillerDBA avatar image KillerDBA ·
Might also help to show us the table(s) definition(s) for any tables referenced in the query, etc.
0 Likes 0 ·

1 Answer

·
BI DWH BALA avatar image
BI DWH BALA answered

Please post the full command. So that, we can check this out.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ellie Ryder avatar image Ellie Ryder ·
This should really be posted as a comment to the question above, rather than an answer.
1 Like 1 ·
BI DWH BALA avatar image BI DWH BALA ·
Yes Ellie Ryder 6. I too aggree. Thanks for noting this. I will take care of this next time. :)
0 Likes 0 ·
Leigh Riffel avatar image Leigh Riffel ·
@BI DWH BALA you can delete the question.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.