Return
-
Title
Error "ORA-00923: FROM keyword not found where expected" when using Duplicate Data function on -
Description
User gets error message "ORA-00923: FROM keyword not found where expected" when using Duplicate Data function on a table with spaces or double quotes in the column name.1. Create a table with spaces in column name such as:CREATE TABLE TEST
(
"Workstation" NVARCHAR2(50),
"Keycode" NVARCHAR2(80),
"User or Company (?) " NVARCHAR2(58),
"Add-Ons" NVARCHAR2(104),
"Keyfile path" NVARCHAR2(147)
)2. In Schema Browser, right click on table, click on Duplicate Data
3. Click on the Duplicate Data (Summary) tab and you'll get the error.
Error occurs because Toad runs the following query which is invalid:
Select Workstation, Keycode, User or Company (?) , Add-Ons, Keyfile path
, count(*) as Occurrences
from TEST
HAVING count(*) > 1
group by Workstation, Keycode, User or Company (?) , Add-Ons, Keyfile path
4. The error does not occur if the table has no spaces, such as the following table:CREATE TABLE TEST2
(
WORKSTATION NVARCHAR2(50),
KEYCODE NVARCHAR2(80),
USERORCOMPANY NVARCHAR2(58),
ADDONS NVARCHAR2(104),
KEYFILEPATH NVARCHAR2(147)
)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.